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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How do I get a count for values in a field

Hi All,

I am developing an app and ran into a speed bump. I have an field that is "Clothes" and inside the field there is "Shirts, Pants, Shorts, and dresses."

How can I make a number count in a text box for each clothing article, so I can show the number of shirts, pants, etc.?

I know how to make a number count for Clothes but not for values inside of a field. If someone can assist that would be great - thanks.

10 Replies
NickHoff
Specialist
Specialist

=num(count({<clothes={'Shirts'}>}clothes),'#,##0')


You could also go into the number format tab and format the numbers there.