Excluding a filter from a particular chart

[Anonymous]

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!

[sunny_talwar]

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

[hic]

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.

[Anonymous]

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?

[hic]

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

[Anonymous]

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