Bar chart totals

[chiso_chiso]

Gurus,

I have worked on my model to point of the attached excel. My next step is to build a chat that will have stacked bars with hot and cold showing the %ntages without minding the product but the whole lot as a total. As in the picture.

[Gysbert_Wassenaar]

Thanks for sharing your story. Good luck with the next step. Perhaps this documents helps: QlikCommunity Tip: How to get answers to your post?

[its_anandrjs]

Explain properly please also with sample load script and short data that help more to the others to help. In attached excel Product is only field or you have other also.

Let me know please

Product	Hot	Cold
Coke	5
Fanta	5
Sprite	12
Ginger	15
Pineapple	8
Total	18	27

Regards,

Anand

[JonnyPoole · Accepted solution]

Here is an example. Note that your data had a 'total' row so to remove that from the load i used a WHERE filter in the script to not load that row.

Attached QVW is the full solution. Screenshot shows the numbers as you want and the breakdown.

LOAD Product,

    Hot,

    Cold

FROM

(ooxml, embedded labels, table is Sheet1)

where Product <> 'Total';

[chiso_chiso]

Thanks Jonathan this helps.