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

How to show cumulative count in measure for all dimesion values in Qlik sense ?

Dear Team,

I have bellow Data set 

ProjectWeekdatesales
ABCweek101/05/202010
ABCweek102/05/202020
ABCweek103/05/202030
ABCweek104/05/202040
ABCweek105/05/202050
ABCweek106/05/202060
ABCweek107/05/202070
ABCweek208/05/202017
ABCweek209/05/202018
ABCweek210/05/202019
ABCweek211/05/202020
ABCweek212/05/202021
ABCweek213/05/202022
ABCweek214/05/202023
 week215/05/202024

 

 

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)

                          03/05/2020 --  it is 10 + 20 + 30 so on.....

Labels (1)
0 Replies