14 Replies Latest reply: Mar 7, 2018 10:52 AM by Matrika Dikshit

# Excluding a filter from a particular chart

Hi,

I am creating a sheet where I have two charts, I want to apply all filters on one chart but all except one on the other.  could you please help me with the best way to do it? I tried using set analysis, something like -

=Sum({<[Reporting Customer]=>}[Gross Sales])  This works well for such cases, but does not work for chart where I do not have an aggregation such as in a histogram, or in cases where I use a calculated field such as % contribution where I basically do sum(sales for a particular customer)/sum (Net sales).

Is there a better way than using set analysis, I tried alternate state, but that wont allow me to apply all except one, I am only able to assign one state to one chart.

Any suggestions are much appreciated!

• ###### Re: Excluding a filter from a particular chart

maybe in ur second chart, just add the filter you don't want to affect ur chart:

sum({<yourFilter>}yourMeasure)

• ###### Re: Excluding a filter from a particular chart

Hi, Yes that works, but this does not work when I do not use an aggregation. For example in histograms, =[Net Sales per kg], how do I alter this to exclude the filter, Customer? Could you please suggest?

• ###### Re: Excluding a filter from a particular chart

And why exactly don't you use aggregation in your expressions?

What's the point?

• ###### Re: Excluding a filter from a particular chart

Basically I want to understand how to exclude a filter in a histogram, here in this case. The histogram only asks for one measure, which is sales in my case. I want to see the frequency based on the sales value.I am not able to figure out where exactly is the expression for y axis which uses count. The default expression for x axis was ser to =net sales which does not use an aggregation.

• ###### Re: Excluding a filter from a particular chart

I think Histogram chart doesn't have any expressions... it is created using a field name... that might be what the concern is

• ###### Re: Excluding a filter from a particular chart

Correct, it only asks to create it based on one dimension. The default expression that was auto created here was =netsales as I selected net sales as the dimension. I am not able to locate the expression for count and here I cannot apply set analysis as it does not have an aggregation.

• ###### Re: Excluding a filter from a particular chart

hic - Is it possible to ignore selections in a histogram chart within Qlik Sense?

• ###### Re: Excluding a filter from a particular chart

Currently, no.

You could create a histogram manually, using

Dimension = Class([Net Sales], 10)

Measure = Count([Net Sales])

Then you can use any set expression in your measure.

• ###### Re: Excluding a filter from a particular chart

Thanks very much, this is exactly what I was trying to do. One of the issue is that the bin width changes automatically with application of filters but in this case that wont happen.

Also, when I create this bar chart, could you help me understand what the grey bar here interpret?

• ###### Re: Excluding a filter from a particular chart

The grey bar is most likely non-numeric values of the field. Blanks, perhaps.

• ###### Re: Excluding a filter from a particular chart

Ah, okay... Thanks a lot for your help!