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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Get Previous Value at group

QlikExperts,

 

Need a solution at group level with required output (last column) as per below sample. Please assist.

ItemGroupItemQuantityOutput
AItem-A20               20
AItem-B3               60
AItem-C6             360
AItem-D4          1,440
AItem-E5          7,200
BItem-A12               12
BItem-B5               60
BItem-C17          1,020
BItem-D16        16,320
BItem-E8      1,30,560

 

One of the  post read that the solution at expression level is =Quantity * Alt(Above(Expr1),1)

Need a group level solution

Labels (1)
1 Reply
tresesco
MVP
MVP

That should work. Please check the screenshot what and how to use as dimensions and expressions:

Capture.JPG