Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table in excel like the following:
Cakes 2016-01 2016-02 2016-03 2016-04 2016-05 2016-06
Chocolate 15 8 25 6 25 14
Vainilla 25 6 5 12 28 6
Strawberry 19 15 11 9 20 4
If I create a table on QlikView is there a way that the dates (2016-01) are being displayed like the above example instead of
Chocolate 15
2016-01 Vainilla 25
Strawberry 19
Chocolate 8
2016-02 Vainilla 6
Strawberry 15
...
Thanks,
Choose pivot as chart-type and drag the column above (like in excel).
- Marcus
see attached file.
You just need to create a pivot table and drag the Date dimension to the upper right!
hope this helps
Choose pivot as chart-type and drag the column above (like in excel).
- Marcus
Great, that's working now.
Is there a way that I have total in the last column and in the bottom?
Cakes 2016-01 2016-02 2016-03 2016-04 2016-05 2016-06 Total
Chocolate 15 8 25 6 25 14 93
Vainilla 25 6 5 12 28 6 82
Strawberry 19 15 11 9 20 4 78
Total 59 29 41 27 73 34
Thanks
Go into the tab presentation (top left area) and enable for each wanted dimension the option partial sums.
- Marcus
This is what I need THANKS!!!!!!