Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.