Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello Melissa,
In this case you should use 'aggr()' function in your expression
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
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
It depends if it is Qlik Sense or Qlik View.
Which one are you using @milser01 ?
Hi Estela,
i am using QlikView but i suppose it would work for Qlik Sense too
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.
Thanks Estela for clarification.
I thought it would work there as well