topic Re: Excluding values in bar chart in QlikView

Excluding values in bar chart

Thu, 25 Sep 2014 09:07:04 GMT

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.

Re: Excluding values in bar chart

MK_QSL — Thu, 25 Sep 2014 09:13:37 GMT

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)

Re: Excluding values in bar chart

Thu, 25 Sep 2014 09:28:36 GMT

Thanks alot Manish.