topic ranking rows in QlikView

ranking rows

ali_hijazi — Mon, 02 Feb 2015 11:04:25 GMT

Dears

got a pivot table with one dimension and sorted by an expression

actually there are two expressions

I'm sorting the results based on the values of the first expression Descending

Now for the second expression I get the following values let's say

100%

95%

80%

95%

100%

70%

...

what I want is add a third expression and rank the results of the second expression as follows:

100% 1

95% 2

80% 3

95% 2

100% 1

70% .....

Please advise

Re: ranking rows

Anonymous — Mon, 02 Feb 2015 11:29:51 GMT

add third expression and use

Rank(second expression)

Re: ranking rows

ali_hijazi — Mon, 02 Feb 2015 11:38:11 GMT

I tried it

but I got 100% for 278 rows and on the second values less than 100% the rank is giving me 279

Re: ranking rows

ali_hijazi — Mon, 02 Feb 2015 11:38:24 GMT

I want to have 2 instead

Re: ranking rows

sunny_talwar — Mon, 02 Feb 2015 11:50:09 GMT

What formula are you using to calculate %? Is it some kind of aggregate function?

Best,

Re: ranking rows

ali_hijazi — Mon, 02 Feb 2015 11:52:37 GMT

no aggr

the thing is that rank is displaying same rank value for similar results i.e. for the values 100% suppose I got 2 rows with 100% the rank displays 1 for each row, however if the value is 95% which is the first value just below 100% , the rank displays 3 instead of 2

Re: ranking rows

robert_mika — Mon, 02 Feb 2015 12:11:07 GMT

What does your first expression look like?

Could you attached your file?

Re: ranking rows

ali_hijazi — Mon, 02 Feb 2015 12:26:33 GMT

look at the example given in the help when you press F1 in QlikView client

the rank function works as the document is behaving in my case

is there a way to give custom ranks?

I want to give rank to the first x lines in the pivot table where x is specified by the user