Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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
Creator III
Creator III

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
Creator III
Creator III

share your expression and error you are getting

Brett_Bleess
Support (Former)
Support (Former)

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.