Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter specific expression result

Hi,

New to Qlik Community.

Need some help on how to create a Listbox filter but using a specific result within an expression column.

I remember briefly that you can make use of if(match(...) but cant get it to work to filter only a specific result.

My expression reads as follows:

if(Count(DISTINCT([Transaction date])) >3,'Multi Trn')

I now need to create a filter to only show "Multi Trn" results

Please help

Thanks a mil

6 Replies
Not applicable
Author

Hello Melissa,

In this case you should use 'aggr()' function in your expression

See: http://help.qlik.com/sense/2.0/en-US/online/#../Subsystems/Hub/Content/ChartFunctions/aggr.htm?Highl...

Try something like this:

if(aggr(Count(DISTINCT([Transaction date])) >3, YOUR_DIMENSION), 'Multi Trn'')

Change YOUR_DIMENSION to the dimension related to the measure  (Count(DISTINCT([Transaction date])))

I hope it helps,

Estela

harsh44_bhatia
Creator
Creator

Hi,

to what i understand you are trying to show some specific values in list box.

For this you need to do to list box>> properties>>General Tab>> Filed drop down scroll to the very end

You will see your expression type your expression there.

You will get the desired value in the list box

Not applicable
Author

It depends if it is Qlik Sense or Qlik View.

Which one are you using @milser01 ?

harsh44_bhatia
Creator
Creator

Hi Estela,

i am using QlikView but i suppose it would work for Qlik Sense too

Not applicable
Author

Hi harshit Bhatia,

It won't. Qlik Sense has a limited set of features compared to Qlik View.

Although it is a 'New to Qlik Sense' discussion, I believe Melissa is using Qlik View, because Qlik Sense does not include Listbox object. It is Filter Pane instead, unless there is something at qlik branch.

harsh44_bhatia
Creator
Creator

Thanks Estela for clarification.

I thought it would work there as well