topic Re: How to set Filter default values in QlikSense in App Development

How to set Filter default values in QlikSense

Mon, 25 Apr 2016 12:15:49 GMT

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

Re: How to set Filter default values in QlikSense

sunny_talwar — Mon, 25 Apr 2016 12:18:14 GMT

Subba would you be able to elaborate what is default means? How is default different from otherwise here?

Re: How to set Filter default values in QlikSense

Mon, 25 Apr 2016 12:35:52 GMT

Sorry for my explanation..

with out any selection, it should show-Safety,Critical,High

other wise - Safety,Critical,High,Medium,Low

Re: How to set Filter default values in QlikSense

sunny_talwar — Mon, 25 Apr 2016 12:39:29 GMT

May be this:

If(GetSelectedCount(Status) = 0, ExpressionWithSetAnalysis = {<Status = {'Safety', 'Critical', 'High'}>}, ExpressionWithoutAnySetAnalysis)

Re: How to set Filter default values in QlikSense

Mon, 25 Apr 2016 12:49:29 GMT

=If(GetSelectedCount[Status]=0,

[Status]={<[Status]={'Safety','Critical','High'}>},[Status])

is it right?

Re: How to set Filter default values in QlikSense

sunny_talwar — Mon, 25 Apr 2016 12:52:04 GMT

No it is not.

1) Are you doing this as a dimension or expression?

2) if it is an expression, what is your current expression?

3) if it is dimension, why don't you use an expression to control the dimension?

Re: How to set Filter default values in QlikSense

Mon, 25 Apr 2016 13:09:13 GMT

1.Dimension.

I am new of this, can you help...

Re: How to set Filter default values in QlikSense

sunny_talwar — Mon, 25 Apr 2016 13:35:48 GMT

Can you use expression instead?

Re: How to set Filter default values in QlikSense

mgranillo — Mon, 25 Apr 2016 15:25:40 GMT

Subba,

Have you tried opening the app in Qlik Sense Desktop, applying your selections, saving the app, then importing it to your server?

This works for me.

Mike

Re: How to set Filter default values in QlikSense

Thu, 28 Apr 2016 01:42:17 GMT

Hi Michael,

sorry to late response. can you help, how to implement..

Sub2u444

Re: How to set Filter default values in QlikSense

mgranillo — Thu, 28 Apr 2016 12:44:08 GMT

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

Re: How to set Filter default values in QlikSense

undergrinder — Fri, 29 Apr 2016 07:25:39 GMT

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).

Re: How to set Filter default values in QlikSense

Anonymous — Tue, 03 Oct 2017 06:31:43 GMT

Hey Can you tell what the expression should be?

Re: How to set Filter default values in QlikSense

lwileczek — Mon, 17 Sep 2018 15:41:16 GMT

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