Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Qlik Sense - select current year on page load

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?

1 Reply
undergrinder
Valued Contributor II

Re: Qlik Sense - select current year on page load

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.

G.