topic Re: rank() in QlikView

rank()

Mon, 01 Jun 2015 09:59:38 GMT

hi, i have script as follows

tab1:

load * Inline [

MANUFACTURER_LDESC,CATEGORY_LDESC,sales

sonata,ACC,50000

lonad,CHEESE CAKE,100000

lonad,ACC,5000000

];

in chart with manufacturer_ldesc as dimension and following as expression;

sum({1<MANUFACTURER_LDESC={"=rank(sum({1<CATEGORY_LDESC={'ACC'}>}sales),4)<=2"}>}sales)

then i got 2 bars in a chart

1 is lonad with 5100000 and other is

sonata with 50000

lonad must be 5000000 right as i filtered out category of 'ACC'.

pls tell me y it is happening !

@jagan,

@hic

swuehl — Mon, 01 Jun 2015 10:02:03 GMT

You only filtered the rank:

sum({1<MANUFACTURER_LDESC={"=rank(sum({1<CATEGORY_LDESC={'ACC'}>}sales),4)<=2"}, CATEGORY_LDESC={'ACC'} >}sales)

MayilVahanan — Mon, 01 Jun 2015 10:05:51 GMT

Hi Prudhvi,

Try like this

=sum({<MANUFACTURER_LDESC={"=rank(sum({1<CATEGORY_LDESC={'ACC'}>}sales),4)<=2"}>}sales)

In your expression,

sum({1<MANUFACTURER_LDESC={"=rank(sum({1<CATEGORY_LDESC={'ACC'}>}sales),4)<=2"}>}sales)

1 restrict the selections

sunilkumarqv — Mon, 01 Jun 2015 10:22:22 GMT

since you have same name across MANUFACTURER_LDESC as lonad were you used dimension

try below that gives desired result

Expression

Sum({1<CATEGORY_LDESC=P({<CATEGORY_LDESC={'ACC'}>})>}sales)

Use Dimension limits show largest value 2

Mon, 01 Jun 2015 12:36:56 GMT

if under acc category, there are other manufacturers, all those will b summed up as others this is againist requirement

Ex:

tab1:

load * Inline [
MANUFACTURER_LDESC,CATEGORY_LDESC,sales
sonata,ACC,50000
lonad,CHEESE CAKE,10
lonad,ACC,5000000
lonafd,ACC,5000
];

then lonad,ACC,5000000 will b shown in 1 bar n there will b others bar wth value 55000