Adding total to a stacked Bar Chart

[Jeevanar]

Hello .

How can we add a total in the stacked bar chart... as there is no option for me do that

I have created a table in qliksense  as below

Customer wise volume.

Total grouped to be used in the chart.

Below screenshot is the chart implemented in Pixel perfect.

 where I am able to add point labels inside the stack, I am unable to add a total

Please help

@Ruggero_Piccoli  as I saw your article on Create a sorted stacked bar chart in PixelPerfect

[Lech_Miszkiewicz]

I am not sure if there is better way of doing it, but my solution is to create grouping dimension to represent total and treat total as the last value of the stack

[Ruggero_Piccoli]

Hi,

Sorry, I have not understood. You want to display in the chart the total of each column? Or do you mean a total as the sum of all columns in the chart?

Best Regards,

Ruggero

[Jeevanar]

Hello Ruggero,

I need the total  to be displayed like this as shown below

for this I have created group in my qliksense object 

[Ruggero_Piccoli · Accepted solution]

Hi,

You already created the column with the totals in the source straight table. Refresh the connection cache then close and reopen the Designer. Run the wizard to edit the chart. 

In the Series, Add one called Totals of type Points

Customize the appearance in Point Labels and run a preview.

Best Regards,

Ruggero

[Jeevanar · Accepted solution]

Hello Ruggero,

Thank you so much for your solution.

Regards Arjun