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.

    Hope this makes sense.

     

    Andy