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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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