To share our learnings on QlikView and Tableau
If Data source has Date column with more than 3 characters for Month (possibly complete month name), it could be interpreted and used in QlikView/QlikSense as below.
date(date#(’08/September/2015′, ‘DD/MMMM/YYYY’), ‘MM/DD/YYYY’)
Note:
Date# – Interpreter function helps QV to understand the source format.
Date – Function used in QlikView to instruct the format that needs to be used for displaying, if format is not specified explicitly, default format will be taken.
Calculated date dimension as immediate dimension to expression in Pivot chart will lead to this error. This should be a bug in QlikView I guess.
Same set of dimensions and expressions are used in below two charts. Bar chart works fine but Pivot throws error.
Dimension: Dim1 and TransDate (Date field just tried to format =Date(TransDate, ‘MM/YY’))
Expression: Sum(Exp1), Sum(Exp2) and Sum(Exp3)
This could be resolved by changing the date format either at script level or at document UI level.
Doing it in script is pretty obvious. If you opt for document UI level modification, try below steps.
Document properties -> Number -> Select the field (TransDate) -> Give the custom format. Followed by that you have to remove the conditional dimension field and add the direct field TransDate.
That’s it, issue is resolved. 🙂
Latest Update: This bug is with 11.2 SR5 version and fixed in higher SRs.
Got a requirement which needs to copy/propagate the selections from one alternate state to another. Default state is not part of it.
Group A selections should reflect on Group B.
Solution:
Document Properties -> Triggers -> Field Event Triggers -> Dim2 (Field used in my example) -> OnSelect -> Action -> Select in Field
Below are the inputs for achieving this.
Field: Dim2
Search String: =only({[Group A}] Dim2)
Alternate State: Group B
Final result:
Happy Qlikking!!
QlikView Shortcut key to bring the list of Shortcuts available in QlikView.
Ctrl + Q+S+C
Note: Hold Ctrl and press Q, S and C sequentially.
For this exercise decided to hit Qlik’s QlikSense demo server.
Accesspoint URL suffixed with “single” word is the entry point for using this functionality.
https://sense-demo.qlik.com/single
“Select an app” drop down will list applications available on the server, select the one which needs to be embedded. Here for this demo I’m considering “CEO Analysis” dashboard.
Next step is to select object, we are free to choose any type of object from available list. I’m selecting “Qualification” chart here.
After selecting the object, prompted by below screen which shows the options for customization.
I overrode one of the property from default options. “No interaction” was on turned on earlier, I turned it off now.
Below URL is copied from Preview pane of previous screen.
Iframe doesn’t work in WordPress so I couldn’t embed the chart here. But ideally code like below should work.
<div>
………………….
src=”https://sense-demo.qlik.com/single/?appid=45b5016e-6616-4047-aa5e-b6d70696634d&obj=tazWUP&select=clearall” width=”100%” height=”550px” frameborder=”0px“>My iFrame
…………………
</div>
Happy Qlikking!!
QlikTab 