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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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