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: 
danieladv
Partner - Contributor II
Partner - Contributor II

Break line chart

Hi.

I would like the line chart line to start at 201704 or alternatively that the chart starts from 201704, but that the calculation for previous periods must follow. 

Data consists 3 years back data.

The calculation is a type of accumulated calculation, so the values ​​from the period before 201704 must be included, but the line should start from 201704.

Is it possible in any way?

MAT actual.PNG

I have tried limitation - but then I lose the values ​​before 201704.

Measures: rangesum(above(total sum(Units),0,12))

Task description:

"MAT is displayed by a line, where each data point is MAT calculation for a specific month. For instance, August 18 will show (MAT August 18 = sum of measure from Sept 17 to Aug 18)"

Labels (2)
1 Solution

Accepted Solutions
sunny_talwar

There are few ways you can do this... basically you need to force the first 11 values to be 0....

If(Min(TOTAL MonthKey, 12)>= MonthKey, RangeSum(Above(TOTAL Sum(Units), 0, 12))))

or

If(RowNo(TOTAL) >= 12, RangeSum(Above(TOTAL Sum(Units), 0, 12))))

View solution in original post

2 Replies
sunny_talwar

There are few ways you can do this... basically you need to force the first 11 values to be 0....

If(Min(TOTAL MonthKey, 12)>= MonthKey, RangeSum(Above(TOTAL Sum(Units), 0, 12))))

or

If(RowNo(TOTAL) >= 12, RangeSum(Above(TOTAL Sum(Units), 0, 12))))
danieladv
Partner - Contributor II
Partner - Contributor II
Author

Great! It works, thank you😀