Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have created a stacked bar in qlik sense and want to see the values as well as % share for the different segments in the stack. How do I achieve this? Please advise.
Regards,
Rony
Hi Juraj,
Yes. Year and product are the dimensions. How do I proceed?]
Rony
This is strange. Can you post a screenshot, ideally with contents of the Properties pane?
Juraj,
What do you mean by contents of the properties pane?
Something like this:
Hi Juraj,
Please see below. The % share of the products are not totaling up to 100%. I am looking for a cumulative value of the products to be shown for each year respectively. be
OK, so the dimension is not [Year], but [Date.autoCalendar.Year], which means the expression should be:
Sum([Volume])/Sum(TOTAL <Date.autoCalendar.Year> [Volume])
EDIT: I also changed [Sales Volume] to [Volume] according the screenshot.
I have used <Date.autoCalendar.Year> itself in my expression
Prod A share for 2014 is being calculated over total volume for all the years. This is the issue. It needs to be calculated over total vol for 2014 but it is not happening.
This is strange. It works for me nicely (I just used Month instead of Product, because I do not have Product in my sample app):
Then I dont know what is going wrong here. I will check this later and see if it works. Thank you for all your help Juraj.
Best Regards,
Rony