Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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';
Thanks for sharing your story. Good luck with the next step. Perhaps this documents helps: QlikCommunity Tip: How to get answers to your post?
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
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';
Thanks Jonathan this helps.