Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excluding values in bar chart

Hi All,

I have a bar chart where I am showing the largest 5 brands based on sales through dimension limits. I have another bar chart where I want to show sales of all the brands, but not the ones which are already there in the largest 5 brands chart.

It will be great if somebody can help me writing the expression to exclude the largest 5 brands based on sales.

Thanks.

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

For TOP 5

Create a Bar Chart

Dimension

Brand

Expression

SUM({<Brand = {"=Rank(SUM(Sales),4 )<= 5"}>}Sales)

FOR Brands Other Than TOP 5

Create a Bar Chart

Dimension

Brand

Expression

SUM({<Brand = {"=Rank(SUM(Sales),4 )> 5"}>}Sales)

View solution in original post

2 Replies
MK_QSL
MVP
MVP

For TOP 5

Create a Bar Chart

Dimension

Brand

Expression

SUM({<Brand = {"=Rank(SUM(Sales),4 )<= 5"}>}Sales)

FOR Brands Other Than TOP 5

Create a Bar Chart

Dimension

Brand

Expression

SUM({<Brand = {"=Rank(SUM(Sales),4 )> 5"}>}Sales)

View solution in original post

Not applicable
Author

Thanks alot Manish.