Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I’ve seen a lot of questions recently from people with backgrounds in Qlik View identifying some features that they use a lot in View but are currently not supported in QlikSense.
In this document I will show you how with the use of an extension you can mimic the behaviour of a Cyclic Group in Sense. I've also attached a working example.
Big thanks to View Profile: erikwett - Qlik Branch and his qsVariable extension that made this possible. It dug me out of a hole where my clients users were asking for the same charts from different points of view.
18/01/2016 Update
I've an update Cyclic Group example to resolve an annoying by product of the cyclical filter example I've given in regard to the label that's displayed in the filter bar.
Big thanks to vadimtsushko for pointing out the solution which makes filtering on this a lot easier for the user to understand.
instead of showing the expression used to determine which value to group on in the filter bar, which is messy and confusing to the user. It now shows the value selected in the filter bar.
02/01/2018 Update
As of November release we now have the ability to update the labels of Dimensions and Measures dynamically as i've shown in the new sample app, before I had to hide or generalize the label which was a bit of a fudge.
Although you can add cyclical filters into individual charts via alternative dimensions already I still feel this is a valid soluton for those with a use case needing to display the users selection over multiple charts and sheets at once.
Hope this makes sense.
Andy
when I use this extension and put in the field that represents month, my results are returned as values such as 42370 and 42401. Any idea what is causing this or how to fix it.
Hi Shannon
You would be best posting an example of your qvf to the community main board and either myself or others can help you better.
Post your sample app and what you think your answer should be and we can steer you in the right direction.
Regards
Andy
I have try to create chart with variable extension , i get incomplete visualization error msg
HI All
can some one help me on the above link . I get stuck.
paul
Excellent work Andy! We are blessed with talent such as you which helped us to bridge the gap between Qlikview and Qlik Sense.
Hi Andy,
I am trying to fast change on measures. I have two Buttons Sales and Quantity. and I want to change expression in chart, I select Sales or Quantity.
I am using:
IF(vTabView=1,$(vSales),
IF(vTabView-=2,$(vQty)))
only show quanity by default, selection on button is not working.
Hi Ajeet
It is possible achieve with out using extension ? As extension is not support in cloud.
Paul Yeo
DIrector
TDS Technology (S) P/L
Whatsapp +65 9326 1804
www.tdstech.com<http://www.tdstech.com>
hi Thanks for reply,
can u please share any example, I was trying extension which was shared by Andy in this post.
Regards
Ajeet
Hi Ajeet
https://community.qlik.com/thread/267063
Kindly click on above link for my example.
Paul Yeo
DIrector
TDS Technology (S) P/L
Whatsapp +65 9326 1804
www.tdstech.com<http://www.tdstech.com>
Pick(Match($(vTabView),1,2)
,$(vSales),$(vQty))
Should work if you are not dynamically setting the dimension just the measure.
Pick and Match is more efficent than IF Statement when calculating results. In your If statement the issue is you havent wrapped the varable vTabView in a $ which would return the current value of the variable and if you go with the IF statement approach you only need to check for 1 as the else is option 2 unless you are planning on adding more options.
Hi Paul
Yes Qlik have included alternate dimensions and measures as standard on certain charts in recent releases which is great and perfect for cloud where extensions are as yet not supported but this solution described offers more than that. You can control the selection across multiple objects not just the one but an entire sheet or app if required. Maybe over kill but for this kind of requirement you still need to use an extension.
Regards
Andy