Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to add the rank function to the stacked charts.
I have two dimensions in my chart:
1) id
2) defect type
In expression number of defects is calculated.
Unfortunatelly the aggr rank function which I used, give me the same results as the rank funtion.
Rank(defect):
rank((count({<counter={'1'}>}
Total <id> distinct(level))), 0, 1)
The output is :
id defect type rank(defect)
1 A 1
2 B 1
1 B 1
I found in the community that for ranking multiple dimensions aggr function is used.
So I tried:
aggr(rank(defect), id, [defect type])
But I get the same results
id defect type raggr(ank(defect), id, [defect type])
1 A 1
2 B 1
1 B 1
What I'm doing wrong?
Is it possible that they all have the same Defect result? QV will rank same results as the same rank number.
Found the following Design Blog post that may help, geared to Sense, but should be applicable here too:
https://community.qlik.com/t5/Qlik-Design-Blog/Rank-Function/ba-p/1466430
Regards,
Brett