Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Prakash0041
Contributor
Contributor

Show cumulative count in measure for all dimesion values in Qlik

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)
1 Reply
Gui_Approbato
Partner - Creator III
Partner - Creator III

Hello,

For that table use the following expression:

 RangeSum(   Above(     Sum(Sales)     , 0, RowNo()     )       )