topic Re: Rank function problem in QlikView

Rank function problem

Mon, 05 Nov 2012 05:01:28 GMT

Can any one please help me in this

I have text column 'QryType'

In pivote chart last column show total of 'QryType' group by Source of Query.

Now I want to show details according to desc order of total.

I used rank function on total column but it showing value in range.

Mon, 05 Nov 2012 05:15:02 GMT

Hi,

You could try this one.

dual('Rank ' & Rank(Sum(Total)), Sum(Total))

Regards,

Janzen

Tue, 06 Nov 2012 08:57:57 GMT

It's not working. I am getting values like

Rank174-225

Rank20

Rank33-34

Rank129-151

Rank13-15

Total column expression is

=TextCount(QryType)

Where QryType is Text Value