Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Chernov
Creator
Creator

Aggr Sums in PivotTable with Hierarchy Groups

Hi, i create tatle for tests:

LOAD RecNo() as ID,

* Inline

[ Group1, Group2, Amount , Shop

GroupN1, Group2N1, 130, Shop1

GroupN1, Group2N2, 50, Shop1

GroupN1, Group2N3, 100, Shop1

GroupN1, Group2N4, 220, Shop1

GroupN1, Group2N1, 97, Shop2

GroupN1, Group2N2, 51, Shop2

GroupN1, Group2N3, 102, Shop2

GroupN1, Group2N5, 77, Shop2

]

in pivot table i want to calculate sums with aggregation by group1 and shop1,

Clipboard02.jpg

but it work for only first group2N1, for other not, - why?

i'll use QlikView 11.2 SR5 (build 12235)

1 Solution

Accepted Solutions
Not applicable

Hi,

would this work for you?

Sum(Aggr(NODISTINCT Sum(Amount),Group1,Shop))

Best regards

Andreas

View solution in original post

4 Replies
Gysbert_Wassenaar

Use sum(total <Shop> Amount). See attached qvw.


talk is cheap, supply exceeds demand
Chernov
Creator
Creator
Author

i don't need it, because in my real tables i use four level hierarchy, and i can't calculate by this expression sum's in group level 2 and 3

in level 0 - i want sum all data

in level 1 - too

but in level 2 - i need know sums by level 1, and in level 3 - i need to know sums by level 2

Not applicable

Hi,

would this work for you?

Sum(Aggr(NODISTINCT Sum(Amount),Group1,Shop))

Best regards

Andreas

Chernov
Creator
Creator
Author

It work's thanks!