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

    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