Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

dimenssions and pivot

Hello there,

can anybody tell me why

=sum (



sum( Qty ) - before ( sum( Qty )))

doesnt work in dimenssions / pivot table?

How to change this?

thank you!

Marta

Labels (1)
1 Reply
GabrielAraya
Employee
Employee

Marta,

Try this: Sum(Qty) - Before(Sum(Qty)), you can't have in the same expression: Sum(Sum()). Maybe: Sum(Aggr(Sum(), .... ))

Gabriel