Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to get total sum in stacked bar?

I have a grouped x-axis drill down dimension.(geo,area,..)

  • when I click on the stacked legend
  • it actually is not displaying the 100% of the all the fields in area level drill down
  • i wrote a set analysis expression
  • how to achieve this in grouped drill down color1.PNG
  • when I click on 46%

color2.PNG

  • the NM/GW , PLAT, PS/CAN ARE SEPERATELY 100%
  • BUT REQUIREMENT IS TO GET THE SUM OF ALL NM/GW+PLAT+PS/CAN=100%
  • I ATTACHED A SIMILAR FILE
  • THANKS IN ADVANCE
4 Replies
ramoncova06
Specialist III
Specialist III

so you want to stack NM/GW , PLAT, PS/CAN in one single bar ? to what level do you want to stack things together ?

Not applicable
Author

i dont want them to stack them to single bar

i want them seperate but

when I click on 46%, i want to the division of 46% in 100% in NM/GW,PLAT,PS/CAN

vikasmahajan

you can store total of  NM/GW+PLAT+PS/CAN  in variable  say vtot  and while display contribution use this variable in expression.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
ramoncova06
Specialist III
Specialist III

you would need to base your aggregations on whatever is selected, and keep going down and since your drilldown has several levels it that makes it a tad more complex, I will try to look into some of my stuff to see if I have something that will work