topic Re: Rank function with multiple dimension in QlikView

Rank function with multiple dimension

kah — Fri, 15 Nov 2024 23:44:38 GMT

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?

edwin — Mon, 26 Oct 2020 17:39:29 GMT

Is it possible that they all have the same Defect result? QV will rank same results as the same rank number.

Brett_Bleess — Wed, 04 Nov 2020 20:58:43 GMT

Found the following Design Blog post that may help, geared to Sense, but should be applicable here too:

Regards,
Brett