Sum Last Year with specific Date

Tue, 13 Nov 2012 10:05:27 GMT

Hi,

I have a table like this:

- TableTransaction (DateTrans, Total)

- TableWeekCY (Year, Week, DateTransCY)

- TableWeekLY (Year, Week, DateTransLY)

Example, I have a data like this:

Year	Week	DateTransCY	DateTransLY
2012	40	09/04/2012 - 09/10/2012	09/06/2011 - 09/12/2011

I want to display Sum(Total) in 2 column, that is Total for CY and LY based on Current Selection (Year and Week). How do the Expression if I made it on the pivot table?

The Output is like this:

TotalCY	TotalLY
999,999	999,999

I norm the table into like this:

- TableWeekCY (Year & '-' & Week as CodeWeekCY, DateTransCY as DateTrans)

- TableWeekLY (Year & '-' & Week as CodeWeekLY, DateTransLY as DateTrans)

Thank you.

topic Sum Last Year with specific Date in QlikView

Sum Last Year with specific Date