7 Replies Latest reply: Nov 6, 2014 4:51 PM by Enrique Colomer

# Totals

Hello,

I have next tab:

Number

G1 S1 Item1 10

G1 S1 Item2 20

G1 S2 Item3 30

G1 S2 Item4 30

G2 S3 Item5 40

G3 S4 Item6 50

Now i want to have totals on several levels

G1 S1 Item1 10

G1 S1 Item2 20

G1 S1 Total 30

G1 S2 Item3 30

G1 S2 Item4 30

G1 S2 Total 60

G1 Total 90

G2 S3 Item5 40

G2 S3 Total 40

G2 Total 40

G3 S4 Item6 50

G3 S4  Total 50

Total 180

How can i do this?

• ###### Re: Totals

See this ...

• ###### Re: Totals

That's it. But how do you do this?

• ###### Re: Totals

You have attached the QV file.

This a pivot table, with 3 dimensions (Group, S and Item) and 1 expression Sum(N) and in the presentation label I put Subtotal by Group and by S dimensions

• ###### Re: Totals

Thx a lot, but i am new to qlikview and the forums.

• ###### Re: Totals

if your question is resolved, you must give the answer (mine) as correct to close

• ###### Re: Totals

Thx! But i have a trial version, so i can't open your document anymore.

I succeeded, but the totals won't succeed.

• ###### Re: Totals

OK, I write for you a detailed solution

The data are in script as this:

Group, S, Item, N

G1, S1, Item1, 10

G1, S1, Item2, 20

G1, S2, Item3, 30

G1, S2, Item4, 30

G2, S3, Item5, 40

G3, S4, Item6, 50

];

execute script

1.- You select a New Graphic, and select Pivot Table

2.- Select as dimensions Group, S and Item elements

3.- Write expression Sum(N)

4.- In label Presentation, select Partial totals in Group and S dimensions

FIN