Mthly dashboard in Qlik sense

[guster999]

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

[jagan]

Hi,

Attach some sample file and let us know your required output.

Regards,

Jagan.

[guster999]

1/ I have cut the App right back to 1 x KPI and limited data from an excel file, but essentially I want the expression calculation and tittle for the KPI to be automated to stay as May 2015 for example until the 1st July – but then display June 2015 until 1st August etc….. (i.e. always showing the previous full months result). However with any other pages I create I want them to be user selected.

2/ I can link to a database directly and get these same columns – when I do this I want to be able to get a daily incremental load with any new rows added.

cheers

Gus Feltham

Senior Data Analyst | Corporate Services

+64 4 912 0352 x352