
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Adding total to a stacked Bar Chart
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
- Tags:
- nprinting
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Ruggero,
I need the total to be displayed like this as shown below
for this I have created group in my qliksense object


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Ruggero,
Thank you so much for your solution.
Regards Arjun
