Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Default Selection in Qlik Sense

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

29 Replies
Highlighted
Contributor III
Contributor III

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

Highlighted
Creator
Creator

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

Highlighted
Creator
Creator

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

Highlighted
Creator
Creator

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

Highlighted
Partner
Partner

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:

Capture.PNG

Then make a bookmark of your current selection as follow:

Capture.PNG

Now in the extension button,

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

Capture.PNG

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?

Highlighted
Creator
Creator

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

Highlighted
Not applicable

I'm having the same problem. ...

Highlighted
Specialist II
Specialist II

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

Highlighted
Partner
Partner

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

Highlighted
Creator
Creator

Hi Omar,

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

Thanks,

Santosh Aravind