QlikView App: Accumulate values in the Data Model

    This example QlikView app shows a number of different ways that values can be accumulated by loading associated tables based on the existing data.

     

    Three scenarios are looked at:

     

    A straight accumulation of values that accumulate to match a total over a number of days.

    A moving annual total where for each period 12 months of values are rolled up.

    Creating an Average bar appearing as an extra bar within a bar chart

     

    In all cases a new dimension is created to allow for the total to be created.

     

    This document was produced to support the Quick Intelligence Blog posting Accumulate Values In The QlikView Data Model.  This blog discusses the techniques used so that you can use them in your own documents.

     

    Please see my other documents uploaded to Qlik Community for further tutorials and examples.

     

    Many thanks,

    Steve Dark

     

    www.quickintelligence.co.uk