Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Filter specific expression result

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
Contributor

Re: Filter specific expression result

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

Re: Filter specific expression result

It depends if it is Qlik Sense or Qlik View.

Which one are you using @milser01 ?

harsh44_bhatia
Contributor

Re: Filter specific expression result

Hi Estela,

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

Not applicable

Re: Filter specific expression result

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
Contributor

Re: Filter specific expression result

Thanks Estela for clarification.

I thought it would work there as well

Community Browser