Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MajaP
Contributor II
Contributor II

How to filter table by measure

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

 

MajaP_1-1648730500365.png

 

 

Labels (1)
5 Replies
Chanty4u
MVP
MVP

Create your measure as a DIMENSION:

and do as follow:

 

aggr(count(YourMeasure),YourDimension)

vinieme12
Champion III
Champion III

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/Dashb...

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
MajaP
Contributor II
Contributor II
Author

And pls tell me how I should implement these functions? 

vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
MajaP
Contributor II
Contributor II
Author

So this should look like this? 

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

I don't think it works properly