topic Re: Ignore selection in 100% stacked bar chart in QlikView

Ignore selection in 100% stacked bar chart

kinjal1645 — Thu, 15 Apr 2021 10:50:46 GMT

Hi All,

How do I ignore a selection in 100% stacked bar chart?

I have attached QlikView file from this source to explain my requirement: https://community.qlik.com/t5/QlikView-App-Dev/100-Stacked-Bar-Graph/td-p/153602

Sum(Amount)/Sum(TOTAL <CLIENT> Amount)

The chart shouldn't change if any CLIENT is selected. For example: If X1 CLIENT is selected then graph shouldn't change, all CLIENTS should display in the bar chart.

Kindly help @sunny_talwar @tresesco @swuehl @Gysbert_Wassenaar

Thank you

Re: Ignore selection in 100% stacked bar chart

eddie_wagt — Fri, 16 Apr 2021 12:54:10 GMT

Maybe like this?

Sum({$<CLIENT=>}Amount)/Sum({1}TOTAL <CLIENT> Amount)

Re: Ignore selection in 100% stacked bar chart

kinjal1645 — Fri, 23 Apr 2021 12:49:00 GMT

I tried this, it didn’t work. It doesn’t give a 100% bar chart

Re: Ignore selection in 100% stacked bar chart

eddie_wagt — Mon, 26 Apr 2021 06:48:15 GMT

What are you exactly trying to achieve? With this expression you get 100% stacked bars and if you select a client then the bars are unchanged, but when you select a month then the bars will be changed. Please provide more information.