3 Replies Latest reply: Apr 24, 2015 10:23 AM by Gysbert Wassenaar RSS

    Historical data into Qlik Sense

    Guillaume Kaisin

      Hello,

       

      I would like to include historical data into my Qlik Sense application.  As an example there is my FCT_Contract table, containing every data about a contract and my HIST_Contract table containing the data by month.

       

       

      fct-agg-contract.png

       

      How can I manage the two sets of data to work within one Qlik Sense application ? I would want to make some comparation vizualisation (between periods) and to have my "classic" vizualisation about my current period also.  I could make a link table to avoid the duplication of every dimensions like this :

       

      fct-agg-contract-link.png

       

      Do I have to duplicate every measure I have in my application ? Lets say I would like to have the count of contract by category.  If I have only one measure "Contract count" (which is filtered by period), I could have this count right only if I have selected one period (current or only one month).  If after I select multiple period to be able to make comparaison between multiple periods, my other vizualisation which work on one period would be false.  I want to avoid this kind of confusion.

       

      Do you have a "best practice" to work with historical data with snapshot date ?

       

      Thanks