Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

crispolo
New Contributor III

Custom Table

Hi guys,

     I need of your help to implement this kind of table in qlikview.

Table_A

Model

TypeabTotal

A

123
B314
C4

3

7
Total86

14

I know how to use the Type's value like a header of table, but I don't know how to calculate the Total row and column.

I use the Pivot table, so I can't calculate the last row, and if I make the Total expression this is calculated for each vale of Type, below there is what I get:

Table_B

ModelTypeaTotalbTotal
A1

1

22
B3311
C4433

Can I get the Table_A, and how?

Thanks to all

1 Solution

Accepted Solutions

Re: Custom Table

Check the attached

Capture.PNG

1 Reply

Re: Custom Table

Check the attached

Capture.PNG

Community Browser