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: 
apoorva11
Contributor II
Contributor II

Consecutive 3 days data on a date in same table

I have data like below . I need to show total order booked and total order billed for next 3 days on a date on key: Store Code& Date& Product Code 

Table in model is like:

Store CodeDateProductTotal Order BookedTotal Order Billed
ABC15 JuneP1108
ABC15 JuneP21210
ABC18 JuneP153
ABC19 JuneP175
ABC20 JuneP184
ABC21 JuneP165

 

Expected Output :

Store CodeDateProductTotal Order Booked Total Order Booked for next 3 days excluding current dateTotal Order Billed for next 3 days excluding current date
ABC15 JuneP1102012
ABC15 JuneP21200
0 Replies