Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dimension limits

Hi all,

I have data set similar to the below one,

NameValue

A

15
B10
C20
D10
E5
F8

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)

1 Solution

Accepted Solutions
maxgro
MVP
MVP

use a calculated dimension

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

and as expression

sum(Value)

1.png

View solution in original post

3 Replies
Chanty4u
MVP
MVP

use exp max()    and set dimenstion limit top3

t_chetirbok
Creator III
Creator III

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
MVP
MVP

use a calculated dimension

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

and as expression

sum(Value)

1.png