Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Valued Contributor

Re: How to apply default selections in QlikSense sheets

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

Re: How to apply default selections in QlikSense sheets

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

Re: How to apply default selections in QlikSense sheets

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

Community Browser