Totals

[#1]

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?

[ecolomer]

See this ...

[#3]

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

[ecolomer · Accepted solution]

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

[#5]

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

Where can i download the attached file?

[ecolomer]

you only have to click on the file to be download

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

[#7]

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

I succeeded, but the totals won't succeed.

[ecolomer]

OK, I write for you a detailed solution

The data are in script as this:

LOAD * INLINE [

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