Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to apply default selections in QlikSense sheets

can anyone guide me in applying the default filter selections when user opens.

I am having an report with monthly data and I wanted to show the recent month as default selection.

how can we do it in Qlik Sense.

thanks in advance

3 Replies
NickHoff
Specialist
Specialist

There are two different ways to accomplish this.  The best is using a bookmark and then using the trigger onload load bookmark.

doc prop.jpg

apply bookmark.jpg

The other is to perform and trigger on load to load a particular set of static values.

edit:  This was in the Qlikview section didn't read the Sense part.  I'm unable to answer you in regards to Sense.

Not applicable
Author

thank you for your response! i know how to do it is QlikView but figuring out on how we can do it in Sense

Not applicable
Author

Hi Chinna,

You could create a variable in the script that calculates the month based on the current date. This could then be used in expressions through Set Analysis.

The variable would update each time the script is reloaded.

Hope this helps.

Rod