Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

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?

1 Solution

Accepted Solutions
ecolomer
Honored Contributor II

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

7 Replies
ecolomer
Honored Contributor II

Re: Totals

See this ...

p01.png

Not applicable

Re: Totals

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

ecolomer
Honored Contributor II

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

Not applicable

Re: Totals

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

Where can i download the attached file?

ecolomer
Honored Contributor II

Re: Totals

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

Not applicable

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.

ecolomer
Honored Contributor II

Re: Totals

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