Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Srikanth
Contributor II
Contributor II

I have weekly data with weekstart and sales as columns, Need to find 2-11 week sum and highest values to the corresponding weeks?

LOAD * INLINE [
WeekStart, Sales
22/03/21, 10
29/03/21, 20
05/04/21, 40
12/04/21, 100
19/04/21, 120
26/04/21, 160
03/05/21, 25
10/05/21, 45
17/05/21, 65
24/05/21, 85
31/05/21, 90
];
 
1. Need to find totals which are in blue colored?
2. Need to find highest sales from  the blue colored data?
Labels (3)
0 Replies