Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Re: how to get total sum in stacked bar?

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

Re: how to get total sum in stacked bar?

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
Not applicable

Re: how to get total sum in stacked bar?

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

Vikas

ramoncova06
Not applicable

Re: how to get total sum in stacked bar?

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