Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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.....

Tags (1)
Labels (1)
1 Reply
Highlighted
Creator
Creator

Re: Show cumulative count in measure for all dimesion values in Qlik

Hello,

For that table use the following expression:

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