topic Re: Dimension limits in QlikView

Dimension limits

Mon, 23 Nov 2015 14:24:19 GMT

Hi all,

I have data set similar to the below one,

I am using a bar chart showing the sum of Value with Name as dimension.

I need to show top 3 only, So i set that in Dimension Limits,

But my exact requirement is i need to show all the Top 3 values irrespective of distint.

Ex. in our we get Top 3 as C(20), A(15), B(10)

but i need C(20), A(15), B(10),D(10)

Chanty4u — Mon, 23 Nov 2015 17:46:48 GMT

use exp max() and set dimenstion limit top3

t_chetirbok — Mon, 23 Nov 2015 18:01:18 GMT

Hello!

You needn't to use dimension limits, but maybe rank help you.

Try this expression if(wildmatch(rank(sum(Value)),'1*','*2*','*3*') ,sum(Value))

maxgro — Mon, 23 Nov 2015 18:03:11 GMT

use a calculated dimension

=AGGR(IF(Rank(sum(Value), 1,1)<=3, Name), Name)

and as expression

sum(Value)