Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe like this?
Sum({$<CLIENT=>}Amount)/Sum({1}TOTAL <CLIENT> Amount)
I tried this, it didn’t work. It doesn’t give a 100% bar chart
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.