QlikView App: Simple Year To Date Example (Set Analysis)

[stevedark]

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

www.quickintelligence.co.uk

[stevedark]

Thank you Isaac, it's very kind of you to say that.

[Anonymous]

Thank you, but do you know if is applicable also in QlikSense ? thanks

[stevedark]

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:

Qlik Sense App: Prior Period Comparison with Set Analsysis