Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
jozisvk11
Contributor

Sum/total column in PIVOT TABLE

Hello,

Can somebody help me how can I add TOTAL column in PIVOT Table.

I have table:

ID          Hours (1.5.2017)      Hours(2.5.2017) ....               

10                    5                              8

12                    8                              12    

17                    11                              5    

19                    13                              6

....

And I need table:

I have table:

ID          Hours (1.5.2017)      Hours(2.5.2017) ....             TOTAL            

10                    5                              8                             13

12                    8                              12                             20

17                    11                              5                             16  

19                    13                              6                             19

....

Thank you for answer my question.

8 Replies

Re: Sum/total column in PIVOT TABLE

Why can't partial Sum from presentation Tab

Or

Sum(TOTAL <Hours> Sales)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
qlikview979
Valued Contributor

Re: Sum/total column in PIVOT TABLE

Are you expecting like this

Untitled.png

qlikview979
Valued Contributor

Re: Sum/total column in PIVOT TABLE

PFA,

jozisvk11
Contributor

Re: Sum/total column in PIVOT TABLE

Yes, but I have only one column in expression.(SET analyse).  The amount of columns is not the same, that changing according to date.

MVP
MVP

Re: Sum/total column in PIVOT TABLE

Have you tried enabling Partial Sum for your second dimension like:

Capture.PNG

qlikview979
Valued Contributor

Re: Sum/total column in PIVOT TABLE

Here my Dimensions are

1)ID,

2)Hours(1.5.2017)

3)Hours(2.5.2017)

Expression:-sum(Hours(1.5.2017))+sum(Hours(1.5.2017))


Untitled.png

jozisvk11
Contributor

Re: Sum/total column in PIVOT TABLE

partial sum is only for dimension.

MVP
MVP

Re: Sum/total column in PIVOT TABLE