I'm very new to QLIK and have a conundrum regarding getting expressions to accumulate across a row in a pivot table.
To give you background - my data has the fields [TransactionDate], [PerformanceDate] [Sales].
I'm looking to create a pivot table which has rows of performance dates and columns of "weeks in advance" (i.e. transaction date minus performance date divided by 7). 0 obviously being transacted on the same week as the performance and -1 being the week before etc.
This is what i have created thus far.
NB: my data has hundreds of weeks in advance. i really only need to see the last 8 but i need full accumulation.
The equivalent of what i'd like to would look like this:
Rows = PerformanceDate
Columns = (TransactionDate-PerformanceDate)/7
Any thoughts or suggestions would be warmly welcomed and thanks for your help in advance.