Skip to main content

New to Qlik Sense

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
rlawton1
Contributor III
Contributor III

Pivot table column dates, reference column's date in expression

I have a pivot table with a valuelist as the dimension and years and months as the columns. In my values i display lots of figures, but for one of the values i want to display a rolling 3 month average. so i need to get the values for the 3 months preceding the current column month.

How would i do this? Is there a way to reference the month of the column in the expression?

 

Labels (2)
1 Solution

Accepted Solutions
rlawton1
Contributor III
Contributor III
Author

I found the answer myself. By using the 'before()' function with an offset of 1, 2,3 for each prior month i wanted to access,

View solution in original post

1 Reply
rlawton1
Contributor III
Contributor III
Author

I found the answer myself. By using the 'before()' function with an offset of 1, 2,3 for each prior month i wanted to access,