Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Create your measure as a DIMENSION:
and do as follow:
aggr(count(YourMeasure),YourDimension)
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
And pls tell me how I should implement these functions?
There are other posts and videos on how to use variableinput in qliksense
So this should look like this?
aggr(count(Count([unique customer identifier]),[unique customer identifier]) ?
I don't think it works properly