topic Re: Bar chart totals in QlikView

Bar chart totals

chiso_chiso — Wed, 22 Oct 2014 14:06:25 GMT

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.

Re: Bar chart totals

Gysbert_Wassenaar — Wed, 22 Oct 2014 14:11:57 GMT

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

Re: Bar chart totals

its_anandrjs — Wed, 22 Oct 2014 14:16:08 GMT

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

Re: Bar chart totals

JonnyPoole — Wed, 22 Oct 2014 14:17:20 GMT

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';

Re: Bar chart totals

chiso_chiso — Wed, 22 Oct 2014 14:22:08 GMT

Thanks Jonathan this helps.