Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I would like to see frequency of each value in Filter pane(Qliksense).How it can be possible?
Example: In Qlikview we can see frequency of each value in list box by checking the show frequency option.
Regards,
Masthan
Something like this?
=Aggr(Dim & ' (' & Count(Dim) & ')', Dim)
Or better this expression...
=Aggr(Only({1<Dim = {"*"}>} Dim) & ' (' & Count({1<Dim = {"*"}>} Dim) & ')', Dim)