Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Mahdoucch03
Contributor
Contributor

the difference of offset value 0 and 1

the difference of offset value 0 and 1 :

 

RangeAvg(above(Sum(Sales),0,3))  and RangeAvg(above(Sum(Sales),1,3))

Labels (1)
1 Solution

Accepted Solutions
marcus_sommer

The difference is just the starting point - the current row or one above. It's easily to comprehend by putting both expression in parallel within a table-chart - and then maybe playing a bit with the parameter-values.

- Marcus 

View solution in original post

1 Reply
marcus_sommer

The difference is just the starting point - the current row or one above. It's easily to comprehend by putting both expression in parallel within a table-chart - and then maybe playing a bit with the parameter-values.

- Marcus