Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Columns subtotals in table

Hello

I would like to have a pivot table like this:

Product A

Product B

Product C

SubTotal

SubTotal

IN

OUT

IN

OUT

IN

OUT

Product A

Product B + C

PT

ES

Others

PT

ES

Others

PT

ES

Others

Jan

8

2

1

4

4

2

1

1

4

2

1

1

15

16

Feb

7

4

3

5

1

2

2

1

2

2

19

10

Mar

9

2

2

2

2

1

1

1

2

1

1

1

13

10

SubTotal 1

8

6

11

5

4

2

5

4

2

SubTotal 2

24

25

7

11

7

11

Total

49

18

18

49

36

The dimensions are "Month", "Products", "IN/OUT" and "Countries" and the respective quantities are given by a sum expression.

For now I've managed to do the majority of the table but i'm lacking the experience to do lines and columns in red.

How can I do the SubTotals columns and lines that I've mencioned above?

Thanks in advance

Tags (3)
3 Replies
jonbrough
Valued Contributor

Re: Columns subtotals in table

Presentation sheet of charts properties, select the dimension in the top left and tick the Show Partial sums checkbox below it. Looks like you'd need to do this for the "IN/OUT" and "Countries" dimensions.

Jonathan

Not applicable

Re: Columns subtotals in table

Thanks jonbroughavone.

I've tried to do that but it creates the total line by line and not column by column which means I end up getting:

Product A

Product B

IN

OUT

Total

IN

OUT

Total

PT

ES

Others

Total

PT

ES

Others

Total

Jan

8

2

1

4

7

15

4

2

1

1

4

8

Feb

7

4

3

5

12

19

1

2

2

4

5

Mar

9

2

2

2

6

15

2

1

1

1

3

5

Total

24

8

6

11

25

49

7

5

4

2

11

19

Which is not what I actually want. Is there any flag or option that I have to enable to do what I pretend?

jonbrough
Valued Contributor

Re: Columns subtotals in table

Not that I know of.

Jonathan

Community Browser