topic Re: Cumulative Items Sold MTD in QlikView

Cumulative Items Sold MTD

rammarthi — Sat, 16 Nov 2024 20:53:31 GMT

Hi,

Please help me with populating cumulative Items sold when we have an item id, date and number of items sold per day.

Please note that every month the cumulative sum should start afresh as shown in the attached file.

Appreciate it, if you can give it for both front end charts and scripting.

Re: Cumulative Items Sold MTD

Vegar — Sun, 12 May 2019 18:37:54 GMT

To get the values in the script try concerning like this:

Load
Emploee ID,
Date,
Items sold,
If( monthname(peek('Date'))=monthname(Date),
peek('Cumulative MTD') + [Items sold],
[Items sold]
) as [Cumulative MTD]
Resident source
Order by Date ;

Re: Cumulative Items Sold MTD

rammarthi — Mon, 13 May 2019 17:17:21 GMT

How can we do this in front end?