topic Qlik Sense - select current year on page load in App Development

Qlik Sense - select current year on page load

Tue, 15 Dec 2015 19:01:19 GMT

I have several years worth of Sales history and have filters on the page to display various measures by Year. When you load the page, not year is selected so you get a summary for ALL years. I would like to automatically (on load) select the current year data without the user needing to physically select the year.

Does anyone know how to automatically filter data on the initial load of the page?

Re: Qlik Sense - select current year on page load

undergrinder — Wed, 16 Dec 2015 04:02:57 GMT

Hi Kenneth,

You can achive this with formulas in objects.

e.g.:

if(getselectedcount(Date)=0,sum({$<Date={'$(=year(now()))'}>} measure),sum(measure))

If no date is selected then
measure = sum of actual year
else measure = sum of all year

You can implement more difficult function to implement what you desire.