Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
kinjal1645
Creator
Creator

Ignore selection in 100% stacked bar chart

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

 

Labels (2)
3 Replies
eddie_wagt
Partner - Creator III
Partner - Creator III

Maybe like this? 

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

kinjal1645
Creator
Creator
Author

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

eddie_wagt
Partner - Creator III
Partner - Creator III

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.