Sum Value by Week No & Month

[#1]

Hi Guys,

I would like to be able to calculate the sum of all invoices per week number for months.

For example.

	WK1	WK2	WK3	WK4	WK5	WK6	WK7	WK8	WK9	W10	W11
Jan	100	100	100	100	40
Feb					60	100	100	100	20
March									80	100	100
Total	100	100	100	100	100	100	100	100	100	100	100

Is QlikView able to calculate into weeks?

[MayilVahanan · Accepted solution]

Hi

Try like this,

In script:

    Load *,Week(DateField) as Week from table;

Then use pivot table

Month and week as dimension

Sum(Invoice) as Expression

Then drag the week dimension in horizontal direction

Hope that helps

[#3]

Thats great thank you.