Discussion board where members can get started with Qlik Sense.
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.
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.
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.
Secondly if you are using a time field like Year-Month start with a simple text value to make sure that works.
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)
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
There is no way for your 2 questions without Extensions AON.