Discussion board where members can get started with QlikView.
I need help to present the number of times each unique word in a collumn apperas. Like COUNTIF in excel.
RED=3 GREEN=1 YELLOW=2
I also want this presented in a diagram with one bar divided in sections for each value.
Thankful for any assistance.
Go to Solution.
No, not if you use COLUMNDATA as dimension, this will group the results like:
You just need to load your data in, then use the COLUMNDATA field as dimension and as expression
Maybe like attached?
Thank you for your answer.
Unfortunately I couldn't open your attachment.
Doesn't =count(COLUMNDATA) return 6 (as the sum of all)?
Thanks a lot for your help.
I think I am to tired here