How to show cumulative count in measure for all dimesion values in Qlik sense ?
Dear Team,
I have bellow Data set
Project
Week
date
sales
ABC
week1
01/05/2020
10
ABC
week1
02/05/2020
20
ABC
week1
03/05/2020
30
ABC
week1
04/05/2020
40
ABC
week1
05/05/2020
50
ABC
week1
06/05/2020
60
ABC
week1
07/05/2020
70
ABC
week2
08/05/2020
17
ABC
week2
09/05/2020
18
ABC
week2
10/05/2020
19
ABC
week2
11/05/2020
20
ABC
week2
12/05/2020
21
ABC
week2
13/05/2020
22
ABC
week2
14/05/2020
23
week2
15/05/2020
24
Basically I want to show in bar graph week1 data i,e in X axis it will show from 01/05/2020 to 07/05/2020 (week1 data) but in measure I want to show cumulative sales amount Example: for 01/05/2020 -- it is 10 02/05/2020 -- it is 10 + 20 (data of 1st May and 2nd May)