topic Re: Totals in QlikView

Totals

Mon, 26 Jan 2026 18:19:17 GMT

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

ecolomer — Thu, 06 Nov 2014 21:08:07 GMT

See this ...

Re: Totals

Thu, 06 Nov 2014 21:12:30 GMT

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

Re: Totals

ecolomer — Thu, 06 Nov 2014 21:17:53 GMT

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

Thu, 06 Nov 2014 21:27:55 GMT

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

Where can i download the attached file?

Re: Totals

ecolomer — Thu, 06 Nov 2014 21:32:55 GMT

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

Re: Totals

Thu, 06 Nov 2014 21:39:48 GMT

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

ecolomer — Thu, 06 Nov 2014 21:51:12 GMT

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