Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
See this ...
That's it. But how do you do this?
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
Thx a lot, but i am new to qlikview and the forums.
Where can i download the attached file?
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
Thx! But i have a trial version, so i can't open your document anymore.
I succeeded, but the totals won't succeed.
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