Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart help

Hello,

I have got the following question. I want to create a chart with the number of unique SERIALS on the y-axis and how many times they are repaired on the x-axis.

The source data looks like this:

REPAIRSERIAL
R000112345
R000212366
R000312367
R000412345
R000512368
R000612345
R000712367
R000812369
R000912370

The chart should look something like this:

error loading image

So it displays the number of unique serials and how many times they are repaired within the selection.

Hope you guys can help!

Regards, Sander

1 Solution

Accepted Solutions
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Sander,

sure, this is what Advanced Aggregation is for:

1. Create a calculated dimension:

=aggr(count(Repair), Serial)

2. Create an expression:

count(distinct Serial)

3. Pretty up and enjoy!

View solution in original post

2 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Sander,

sure, this is what Advanced Aggregation is for:

1. Create a calculated dimension:

=aggr(count(Repair), Serial)

2. Create an expression:

count(distinct Serial)

3. Pretty up and enjoy!

Not applicable
Author

Advanced aggregation.... Off course...

Thanks, Oleg! You're the man!