topic How to filter table by measure in Visualization and Usability

How to filter table by measure

MajaP — Thu, 31 Mar 2022 12:43:45 GMT

Hi,

I have a table like below. I'd like to filter by second column to see how many customer have used my service 7 times, 11 times etc.
How can I apply such a filter?

Thank you for your help

Re: How to filter table by measure

Chanty4u — Thu, 31 Mar 2022 13:30:02 GMT

Create your measure as a DIMENSION:

and do as follow:

aggr(count(YourMeasure),YourDimension)

Re: How to filter table by measure

vinieme12 — Fri, 01 Apr 2022 03:42:46 GMT

try below

Dimension = 685

MEasure=

if (count([unique customer indentifier]) >= 7, count([unique customer indentifier]) )

you can replace the value of 7 with a variable slider to make it dynamic

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Visualizations/DashboardBundle/variable-input.htm

Re: How to filter table by measure

MajaP — Fri, 01 Apr 2022 10:33:17 GMT

And pls tell me how I should implement these functions?

Re: How to filter table by measure

vinieme12 — Fri, 01 Apr 2022 11:22:42 GMT

There are other posts and videos on how to use variableinput in qliksense

Re: How to filter table by measure

MajaP — Thu, 07 Apr 2022 10:20:25 GMT

So this should look like this?

aggr(count(Count([unique customer identifier]),[unique customer identifier]) ?

I don't think it works properly