Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

robertocesp
Contributor 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,

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: How to display a table as in Excel?

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

- Marcus

View solution in original post

5 Replies
Highlighted
Frank_Hartmann
Honored Contributor II

Re: How to display a table as in Excel?

see attached file.

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

hope this helps

Highlighted
MVP & Luminary
MVP & Luminary

Re: How to display a table as in Excel?

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

- Marcus

View solution in original post

Highlighted
robertocesp
Contributor II

Re: How to display a table as in Excel?

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: How to display a table as in Excel?

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

- Marcus

Highlighted
robertocesp
Contributor II

Re: How to display a table as in Excel?

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