I want to make a default selection in the Qlik Sense app.
For example, I am having a year filter with years with 2007,2008,2010. When i open the app I want to see the 2010 year as the default selection and the respective data in the other sheets.
I tried saving the app after doing the selection, however when i refresh the app the selection is not visible and it is going to its default stage.
Can some one please tell how to do it.
There is an extension that can do that ; Styled List:
Example of use:
Field timeframe containing 3 values. I want to have 'annuel' selected by default when I open the app
Result: when I open the sheet :
I find it selected:
As variant, you can create bookmarks with the required selections and then in the charts include these bookmarks in Set Analisys expressions.
This extension is not working fine.
can you please post screen shot.
can you check it once?
one more this is I want to write an expression for default selection.
Can you please explain where the extension is not working properly. What is the expression you want to write for the default selection?
I have used the if condition in the expression. If(Empid=1,Empid) and click on done and selected the button/checkbox and then refreshed the app. It works as expected sometimes.
please post an example which you have worked on and what is the error are you getting. Please tell us the problem which you have faced now.
Thanks for the Extension link. This extension behaviour seems to be inconsistent. For the first time i used the extension it is working as expected(default selection is happening) however after refreshing the app for couple of times the selection is not happening by default. After sometime again it is working as expected. If you have used the extension can you please tell me where am i doing wrong.
And I forgot to mention earlier, after using the extension and reloading the app for couple of times i am getting some "Internal Engine Error".
Did you get that type of error while using this extension.
What I would do, is using another extension: (you'll find it attached)
This one is really stable and offer good options (I'm always using it):
To resume what I do,
I create buttons in each sheet (for navigation);
each button will be used as a navigation button to open a new sheet + setting up an action (in your/my case, applying bookmarks):
Here's a scenario:
Create an Introduction sheet (which contains introductions, KPIs etc..) and buttons to each sheet :
Navigation behaviour: go to specific sheet
action: apply bookmark (your bookmark would be the year you want to select)
This way, when you open your dashboard, you'll first open your introduction page, then click on a button to go to another sheet:
It will transfer you to the desired sheet and apply your bookmark (select the year)
Example: I click on rapport: it will tranfer me to the report sheet and apply bookmark(see the filter pane)
Try it, you'll like it ;