Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This QlikView shows how basic Set Analysis syntax can be used to deliver a view of Year To Date figures.
Two subtly different approaches are given, one using a Pivot table to give the months as a dimension, the other using a Straight Table. The first approach is the quickest and easiest to implement - whilst the other gives more flexibility (in this case to add both Total and Average columns).
The QlikView was originally written as a response to the following QlikCommunity thread: http://community.qlik.com/message/132639
Steve Dark
Thank you Isaac, it's very kind of you to say that.
Thank you, but do you know if is applicable also in QlikSense ? thanks
Yes, this would work the same. You can use the QlikView Converter helper in the Dev Hub to bring in the example QVW and then go from there. This example app I have shared is in Sense, and uses similar techniques: