Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist II
Specialist II

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.