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: 
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