Solved: Re: How to display a table as in Excel? - Qlik Community

Anonymous · ‎2016-11-11

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,

marcus_sommer · ‎2016-11-11

Choose pivot as chart-type and drag the column above (like in excel).

- Marcus

Frank_Hartmann · ‎2016-11-11

see attached file.

You just need to create a pivot table and drag the Date dimension to the upper right!

hope this helps

marcus_sommer · ‎2016-11-11

Choose pivot as chart-type and drag the column above (like in excel).

- Marcus

Anonymous · ‎2016-11-11

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

marcus_sommer · ‎2016-11-11

Go into the tab presentation (top left area) and enable for each wanted dimension the option partial sums.

- Marcus

Anonymous · ‎2016-11-11

This is what I need THANKS!!!!!!