Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
knightwriter
Creator III
Creator III

'count' a particular selection

Hi,

Ive a column of data that contain fruit types. Whats the expression I use to count say apples only for use in a text object?

Thank you.

4 Replies
Qlik1_User1
Specialist
Specialist

Count({<fruits={'Apple'}>}fruits)

knightwriter
Creator III
Creator III
Author

thanks for the response but this doesnt work. If replaced the column header name with the exact in the excel sheet and the exact name within the column and still get an error.

 

Any other suggestions? 

Qlik1_User1
Specialist
Specialist

share your expression and error you are getting

Brett_Bleess
Former Employee
Former Employee

I would have to venture the issue may be in your data model in this case, as I believe the poster had the correct formatting, but I am including a Design Blog post on Set Analysis you can review to ensure things are correct there, and I am including Help link too just in case, will need further information, best thing would be the QVW file, so folks can see the data model and expressions you are using...

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.