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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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