Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
rammarthi
Creator
Creator

Cumulative Items Sold MTD

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.

 

1 Solution

Accepted Solutions
Vegar
MVP
MVP

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 ;
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

2 Replies
Vegar
MVP
MVP

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 ;
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

rammarthi
Creator
Creator
Author

How can we do this in front end?