Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mastankomatla21
Contributor III
Contributor III

Frequency count in Filter Pane

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

 

2 Replies
JGMDataAnalysis
Creator III
Creator III

Something like this?

=Aggr(Dim & ' (' & Count(Dim) & ')', Dim)

 

JGMDataAnalysis
Creator III
Creator III

Or better this expression...

=Aggr(Only({1<Dim = {"*"}>} Dim) & ' (' & Count({1<Dim = {"*"}>} Dim) & ')', Dim)