Default Selection in Qlik Sense

[svinnakota]

Hi All,

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.

Thanks,

Santosh

[Anonymous]

Santosh,

You can have a default selection being forced using a combination of IF condition and set analysis like this...

If (

GetSelectedCount([Bank Name])<>1,

//this is true if no bank is selected and when the app is opened first time

Sum({<[Bank Name]={'My Bank'},Items={'Total Assets',

'Total Liabilities'}>}Value),

//this is else clause, it will show details for the selected bank

Sum({<Items={'Total Assets',  'Total Liabilities' }>}Value)

)

I have a filter named 'Bank Name' and the IF condition is used to check if any selection is made in it by the user. However given at the app opening the user has not had a chance to 'select' anything, I am using Set Analysis in the next line to make the selection for the user. 'My Bank' is the actual value in the filter that I am now forcing in the bar chart.

Let me know if this works for your case.

Thanks,

Ajit

[svinnakota]

Hi Ajit,

Thanks for the reply. I am having more no of sheets and objects in my QVF. It will be a big task to write the if condition for all the expression which i have used.

Thanks,

Santosh

[svinnakota]

Hi Omar,

Sorry for the delay reply, I tried using the Navigation extension. In the action tab i selected the First action as "Select Value in Field" and specified the value, however it is not selecting the value as default from the respective field which i defined.In the same way i defined the second action and gave the same values, still it is not selecting the default value. Could you please tell me how are you able to make the default selection using the "Select Value in Field" action.

Thanks,

Santosh

[svinnakota]

Hi Andrey,

I am having filter in my sheet.I want to see the year selected when i open the app. so that the respective data will be filtered from all the sheets.

Thanks,

Santosh

[OmarBenSalem]

Hi Santosh,

If you wanna have Year 2017 selected by default.

Create a Bookmark and name it 2017 then call it.

How to do so?

Make your selections:

Then make a bookmark of your current selection as follow:

Now in the extension button,

You add an action: apply bookmark and select your bookmark.

With that, when you'll navigate on a specific sheet when clicking in the button, it will also activate your bookmark and thus you'll find the year 2017 and timeframe annuel selected.

Hope this helps?

[svinnakota]

Hi Omar,

Thanks for explaining step by step. I am having a Year filter in my home page. I don't want to select any filter or button. Initially when i open the app i need to see the 2017 year as selected and the respective data in the objects.

Just like how the trigger works in the QlikView. In the same way i need to make the default selection in my home page.

Thanks,

Santosh

[#8]

I'm having the same problem. ...

[JustinDallas]

Unrelated to the problem at hand, but that's a beacoup nice looking dashboard.

[OmarBenSalem]

You have to put the field name btwn quotes and the values without quotes

[svinnakota]

Hi Omar,

Could you please explain clearly. An example app would be helpful if possible.

Thanks,

Santosh Aravind