1 Reply Latest reply: Nov 9, 2017 8:47 PM by Neil Gabin RSS

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

    chitraxi raj

      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.

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

          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