Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Accumulation in a Pivot Table?

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.10days out.JPG

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:

10 days out 2.JPG

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

2 Replies
Highlighted

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

Contributor
Contributor

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