Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
robertocesp
Creator II
Creator II

How to display a table as in Excel?

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,

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

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

- Marcus

View solution in original post

5 Replies
Frank_Hartmann
Master II
Master II

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
MVP & Luminary
MVP & Luminary

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

- Marcus

robertocesp
Creator II
Creator II
Author

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
MVP & Luminary
MVP & Luminary

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

- Marcus

robertocesp
Creator II
Creator II
Author

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