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: 
Srinivas
Creator
Creator

I want see only more than 2 frequency values in List box

Hi All,

In List box If you select show Frequency then that would shows all frequency values of each value. In this I want see only more that 2 frequency values in same List box or another List box.how we can resolve this issue.

Could you please help on this i am eagerly waiting for your response.

Thanks & Regards

Minna

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

=Aggr(If(Count(Field)>2, Field), Field)

PFA

View solution in original post

5 Replies
tresesco
MVP
MVP

Try like:

=Aggr(If(Count(Field)>2, Field), Field)

PFA

sujeetsingh
Master III
Master III

Muna you can aggregate the field count as suggested by tresco

Srinivas
Creator
Creator
Author

Thanks for your reply..

I didn't get correct answer could u please explain with one more example.

Thanks & Regards

Munna

tresesco
MVP
MVP

Try to create a sample qvw and explain your expected output there. May be that would be a better option for us to help you.

ashwanin
Specialist
Specialist

Hi Munna,

Put the formula suggested by Tresesco in List box

Go to List box -->Properties-->Fields-->Select Expression-->Put formula (Change Field to the exact name of field which you want)--> Ok