Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Count number of unique values and present it in a diagram

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

Data Count(Data)

6
Green 1
Red 3
Yellow 2
4 Replies
swuehl
Not applicable

Re: Count number of unique values and present it in a diagram

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

Count number of unique values and present it in a diagram

Thank you for your answer.

Unfortunately I couldn't open your attachment.

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

swuehl
Not applicable

Count number of unique values and present it in a diagram

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

Count number of unique values and present it in a diagram

Thanks a lot for your help.

I think I am to tired here

Bye