Qlik Community

Qlik Sense Enterprise Documents & Videos

Documents & videos about Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT

Makes Sense to go round in circles

ogster1974
Honored Contributor II

Makes Sense to go round in circles

 

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

Attachments
Comments
shannonmarshall
New Contributor

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.

0 Likes
ogster1974
Honored Contributor II

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

0 Likes
paulyeo11
Valued Contributor III

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

0 Likes
rahulpawarb
Valued Contributor III

Excellent work Andy! We are blessed with talent such as you which helped us to bridge the gap between Qlikview and Qlik Sense.

0 Likes
qlikviewajeet
New Contributor III

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.

0 Likes
paulyeo11
Valued Contributor III

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>

0 Likes
qlikviewajeet
New Contributor III

hi Thanks for reply,

can u please share any example, I was trying extension which was shared by Andy in this post.

Regards

Ajeet

0 Likes
paulyeo11
Valued Contributor III

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>

0 Likes
ogster1974
Honored Contributor II

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.

0 Likes
ogster1974
Honored Contributor II

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

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2015-08-24 10:40 AM
Updated by: