Setting a Rank Value in Expression

Fri, 20 Feb 2015 19:56:09 GMT

All,

I am trying to set a rank value as a column in a straigt table but I am unsure the exact expression. My data set is as follows:

Location	Exceptions	Rank
A	5
B	8
C	3
D	6
E	9
F	5
G	2
H	4

I want the expression in "Rank" column to return a value A(<.25), B(.25 to .50), C(.50 to .75), D(>.75) based on quartile value of exception against total exceptions.

There are multiple dimensions so i would need this to aggregate.

Thanks

Re: Setting a Rank Value in Expression

sunny_talwar — Fri, 20 Feb 2015 20:36:18 GMT

Try this as your expression.

=If(Exception < Fractile(TOTAL Exception, 0.25), 'A', If(Exception < Fractile(TOTAL Exception, 0.5), 'B', If(Exception < Fractile(TOTAL Exception, 0.75), 'C', 'D')))

Also please find atttached a qvw file.

Best,

topic Re: Setting a Rank Value in Expression in QlikView

Setting a Rank Value in Expression

Re: Setting a Rank Value in Expression