Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
I have something similar to below table:
Primary Code | Comment | Secondary Code | Details |
P1 | Good | P1-11 | Fast Service |
P1 | Good | P1-11 | Fast Service |
P2 | Good | P2-12 | Clean workshop |
P2 | Good | P2-13 | High Service Quality |
N1 | Bad | N1-13 | Waiting for long |
N2 | Bad | N2-13 | Bad Quality |
N1 | Bad | N1-13 | Waiting for long |
I want to group Comment column together and then count them, then have another column that group Details based on the Comment category, the end result will be something as below:
Comment | Total | Detail | Total |
Good | 4 | Fast Service | 2 |
Clean workshop | 1 | ||
High Service Quality | 1 | ||
Bad | 3 | Waiting for long | 2 |
Bad Quality | 1 |
Detail are group based on Comment or Primary Code (or it's sub group)
Hello,
you need to measures:
for the total:
aggr(Count([Primary Code]),Comment)
second measure:
Count([Secondary Code])
Bear with me, I'm new to qlik. These measures will be written in some kind of table or when we load the data?