Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

chitraxi
New Contributor II

How to set default values for filters or How to set Default bookmark?

My requirement is whenever I load my sheet it should load with some default selection instead of showing all values. For that, I think there are two options

1) setting default bookmark without using extension

2) Defaults values for each filter

I am not able to figure out how to achieve this in a qlik sense.

Tags (1)
3 Replies
neil_gabin
New Contributor III

Re: How to set default values for filters or How to set Default bookmark?

Hi there

I found this extension (Default Selection) which works quite well. It took me a while to get it to work (I'm a newbie too), but I finally got there. Hope this helps.

http://branch.qlik.com/#!/project/590e0d8475aa3cff35e4f61b

Firstly, regardless of which "Initial Selection Mode" you chose, make sure you clear all selections, save and close the sheet, then reopen the App and sheet to see the latest changes.

qlik_1_2.jpg

Secondly if you are using a time field like Year-Month start with a simple text value to make sure that works.

Field: Year-Month

Initial Selection: ='2018-Oct'

Once you are happy it is working, then play with the expression and make sure it evaluates to a string that matches your field selector; not a date value.

My formula is this...

=Year(AddMonths(Now(),-1)) & '-' & Month(AddMonths(Now(),-1))

Finally, you may want to Hide the extension object (un-tick Visible)

YIC

Neil

Employee
Employee

Re: How to set default values for filters or How to set Default bookmark?

You can use the Default Bookmark capability in Qlik Sense.
Check out this video on how to do it.

Qlik Sense Dynamic Default Bookmark Selection On Open - YouTube

Re: How to set default values for filters or How to set Default bookmark?

There is no way for your 2 questions without Extensions AON.