Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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,