Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
but it work for only first group2N1, for other not, - why?
i'll use QlikView 11.2 SR5 (build 12235)
Hi,
would this work for you?
Sum(Aggr(NODISTINCT Sum(Amount),Group1,Shop))
Best regards
Andreas
Use sum(total <Shop> Amount). See attached qvw.
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
Hi,
would this work for you?
Sum(Aggr(NODISTINCT Sum(Amount),Group1,Shop))
Best regards
Andreas
It work's thanks!