Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to set Filter default values in QlikSense

Hi,

I have a Status Filter in that values are - "Safety,Critical,High,Medium,Low"

Default i should show "Safety,Critical,Hot", other wise i should show 5 values.

any one can help with the expr...

Sub2u444

13 Replies
mgranillo
Specialist
Specialist

Subba,

I reread your question and I don't think my suggestion will fully accomplish what you're asking.  It will simply apply filters when the app opens.  If that's the route you want to go, open the app in Qlik Sense Desktop.  Apply your status filter, then make a change to the app so the save button is active.  Save the app.  You'll see that every time the app opens it will apply your selections.  The user will then need to remove all selections to get to the complete set. 

Sunny's suggestion will work if you want Safety,Critical,High to show on opening without any selections but you'll need to code the set analysis into every chart expression. 

Sunny's code is correct but a little hard to interpret.

Sunny is saying your expression should be "If(GetSelectedCount(Status) = 0, sum({<Status = {'Safety', 'Critical', 'High'}>}YourColumn), sum(YourColumn))"

You don't need to use sum, any aggregation function will work, I'm just using as an example.

Mike

undergrinder
Specialist II
Specialist II

Hi Subba,

It is (only) possible through extension.

http://branch.qlik.com/#/project

I can't remember in which one implemented that functionality (some listbox extension).

G.

Anonymous
Not applicable
Author

Hey Can you tell what the expression should be?

lwileczek
Contributor III
Contributor III

Looks like Qlik remade their branch page so all links in here direct to a generic page. Qlik branch is now Qlik Branch