- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
'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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Count({<fruits={'Apple'}>}fruits)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
share your expression and error you are getting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Regards,
Brett
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.