Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

Daily Stock

Hi

I need to calculate a daily stock.

Below I show an example of the calculation that I need

Immagine.png

2 Replies
MVP
MVP

RangeSum(Above(Count(ticket),0,RowNo()))

or

RangeSum(Above(Total Count(ticket),0,RowNo()))

Partner
Partner

Here are some other options:

2) Use the Checkbox "Full accumulation" in the charts expressions tab

3) pre-calculate the cumulative value in the script. This way the cumulative value of a specific month doesn't change even if you make selections in calendar.

(Examples in the qvw file below)