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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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