https://community.qlik.com/t5/App-Development/Cumulative-values-weeks-out-calculation/m-p/2140198#M92692 <P>Hi all,&nbsp;</P> <P>I have the following columns - event name, start date of event, how many days away from the start date we are (not sure if that's useful), total sales. Basically it looks as follows:&nbsp;<BR /><BR />Event Name&nbsp; &nbsp; &nbsp; Start Date&nbsp; &nbsp; &nbsp; &nbsp; Days Out To Event&nbsp; &nbsp; &nbsp; Total Sales&nbsp;<BR />Test Event&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22/11/2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50 000<BR /><BR />I want to have a chart where I can see cumulative sales distributed by weeks out to the event. For example, for the above event all sales happened within 5 weeks before the event. Week 1 we sold 10k, week 2 we sold 20k, week 3 - 0, week 4 - 20k and week 5 - 0, so a total of 50 000. Essentially I want this to look like that in Qlik (the numbers refer to the weeks out):<BR /><BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<BR />Event Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<BR />Test Event&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10 000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30 000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30 000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50 000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50 000<BR /><BR />5 is 10k, then 4 is 10k + 20k, 3 is 10k+20k+0 etc...<BR /><BR />Please help! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 22 Nov 2023 09:39:05 GMT SilviyaK 2023-11-22T09:39:05Z https://community.qlik.com/t5/App-Development/Cumulative-values-weeks-out-calculation/m-p/2140198#M92692 <P>Hi all,&nbsp;</P> <P>I have the following columns - event name, start date of event, how many days away from the start date we are (not sure if that's useful), total sales. Basically it looks as follows:&nbsp;<BR /><BR />Event Name&nbsp; &nbsp; &nbsp; Start Date&nbsp; &nbsp; &nbsp; &nbsp; Days Out To Event&nbsp; &nbsp; &nbsp; Total Sales&nbsp;<BR />Test Event&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22/11/2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50 000<BR /><BR />I want to have a chart where I can see cumulative sales distributed by weeks out to the event. For example, for the above event all sales happened within 5 weeks before the event. Week 1 we sold 10k, week 2 we sold 20k, week 3 - 0, week 4 - 20k and week 5 - 0, so a total of 50 000. Essentially I want this to look like that in Qlik (the numbers refer to the weeks out):<BR /><BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<BR />Event Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<BR />Test Event&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10 000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30 000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30 000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50 000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50 000<BR /><BR />5 is 10k, then 4 is 10k + 20k, 3 is 10k+20k+0 etc...<BR /><BR />Please help! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 22 Nov 2023 09:39:05 GMT https://community.qlik.com/t5/App-Development/Cumulative-values-weeks-out-calculation/m-p/2140198#M92692 SilviyaK 2023-11-22T09:39:05Z https://community.qlik.com/t5/App-Development/Cumulative-values-weeks-out-calculation/m-p/2140374#M92724 <P>Rangesum() with above() functions should work for your case if you use them in table with given dates(weeks) and sales fields.</P> Wed, 22 Nov 2023 14:30:12 GMT https://community.qlik.com/t5/App-Development/Cumulative-values-weeks-out-calculation/m-p/2140374#M92724 MATC 2023-11-22T14:30:12Z