2 Replies Latest reply: Jul 2, 2015 10:38 PM by Gus Feltham RSS

    Mthly dashboard in Qlik sense

    Gus Feltham

      2 queries for my Qlik Sense App:

       

      1/ I want to create a dashboard for my app, that contains kpi's that default to the latest full month for various measurements.  so I need both the data measure expression and the title to have code that calculates for example Jun-15 as the MMM-YY from 1st July until 31st July - then on 1st Aug it will change to Jul-15 for measure calc and title, etc, etc...

      can I use set analysis for this? 

      Note that I have other pages in the app where the MMM-YY are variable as per filter pane selection for users, but I want any selections here kept independent from the dashboard.

       

      2/ The data is linked to an database that includes a date record field (DD/MM/YYYY hh:mm TT) that also needs a daily incremental load (appended with new records only) added into load script.   Is there standard template code avail to do this?

       

      thanks

      Gus