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: 
Not applicable

Count number of unique values and present it in a diagram

Hi

I need help to present the number of times each unique word in a collumn apperas. Like COUNTIF in excel.

COLLUMNDATA

Red

Red

Green

Red

Yellow

Yellow

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.

Best Regards

Malte (Sweden)

1 Solution

Accepted Solutions
swuehl
MVP
MVP

No, not if you use COLUMNDATA as dimension, this will group the results like:

Data Count(Data)

6
Green 1
Red 3
Yellow 2

View solution in original post

4 Replies
swuehl
MVP
MVP

You just need to load your data in, then use the COLUMNDATA field as dimension and as expression

=count(COLUMNDATA)

Maybe like attached?

Not applicable
Author

Thank you for your answer.

Unfortunately I couldn't open your attachment.

Doesn't =count(COLUMNDATA) return 6 (as the sum of all)?

swuehl
MVP
MVP

No, not if you use COLUMNDATA as dimension, this will group the results like:

Data Count(Data)

6
Green 1
Red 3
Yellow 2
Not applicable
Author

Thanks a lot for your help.

I think I am to tired here

Bye