Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
martinr_
Creator
Creator

RangSum per Year

I have the following dimensions year-calendar week.

Now i want to have a cumulative sum per year.

But should always start at the beginning of the year.

This formula does not start at zero at the beginning of the year in an line diagram. in an tabel it is fine.

I do not find a solution.


RangeSum(Above(Sum({<TYP={'SALES'}>}PRICE),0,RowNo()))

1 Solution

Accepted Solutions
sunny_talwar

Create Week(DATUM) as Week in the script and then try this

Aggr(RangeSum(Above(Sum({<BELEGTYP={'AB'}>}GESPREISNETTO),0,RowNo())), GESCHAEFTSJAHR, (Week, (NUMERIC)))

View solution in original post

17 Replies
sunny_talwar

Try this

Aggr(RangeSum(Above(Sum({<TYP={'SALES'}>}PRICE),0,RowNo())), FiscalYear, (Week, (Numeric)))

martinr_
Creator
Creator
Author

Hi Sunny !

If I use the so, the line runs to 0.



accu2.JPG

sunny_talwar

What are the two dimensions that you use in your chart on the right?

martinr_
Creator
Creator
Author

accu3.JPG

KW

Dual(Num(YEAR([DATUM]),00)&'-KW'&Num(Week([DATUM]),00),Num(YEAR([DATUM]),00)&NUM(Week([DATUM]),00))

Nettopreis

Aggr(RangeSum(Above(Sum(.........

sunny_talwar

Not talking about the line chart.... but the chart next to it... What are the two dimensions used here?

Capture.PNG

martinr_
Creator
Creator
Author

2015/2015 or 2016/2017 is fiscalyear.

the other one is the week from an datefield.

sunny_talwar

Have you used these two dimensions in your chart? Would you be able to share a sample?

martinr_
Creator
Creator
Author

No i have used other.

How can i shared it with data?

sunny_talwar

Look here on how to upload: Uploading a Sample