'count' a particular selection

[knightwriter]

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.

[Qlik1_User1]

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

[knightwriter]

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]

share your expression and error you are getting

[Brett_Bleess]

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