topic Re: Accumulation in a Pivot Table? in QlikView

Accumulation in a Pivot Table?

Anonymous — Fri, 20 Jul 2018 14:46:46 GMT

Hello,

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:

Dimensions

Rows = PerformanceDate

Columns = (TransactionDate-PerformanceDate)/7

Expression

Sum(Sales)

Any thoughts or suggestions would be warmly welcomed and thanks for your help in advance.

Paul

Re: Accumulation in a Pivot Table?

sunny_talwar — Fri, 20 Jul 2018 15:19:09 GMT

Would you be able to provide data behind this output to see how your data is and test out few ideas

Re: Accumulation in a Pivot Table?

Anonymous — Fri, 20 Jul 2018 15:33:44 GMT

Thanks for the quick reply. I've attached an excel sheet with similar data which i had to hand.

The multiple lines are from different sources hence multiple entries with the same transaction date / performance date.

Thanks Paul