topic Rank Function in QlikView

Rank Function

Fri, 16 Jan 2015 12:41:59 GMT

Hi,

I have attached the samle QVW with the sample. Please could you have a look and advise.

I trying to calculate the 'Quartile Function' , i.e '(No of Rows + 1 ) /4 '

When I do No of rows I get '17' and after doing the calculation it will be 5.

I want to get the value '500' which is against the value '5'

Thanks,

Sijo

Re: Rank Function

Fri, 16 Jan 2015 14:15:54 GMT

You can use min function instead of rank to get the desired out out.

something like this... Min(Amount,<your number>)

e.g: Min(Amount, 5)

Re: Rank Function

Fri, 16 Jan 2015 14:16:17 GMT

Thanks