topic Re: Sum Value by Week No & Month in QlikView

Sum Value by Week No & Month

Wed, 19 Sep 2012 12:55:29 GMT

Hi Guys,

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

For example.

Is QlikView able to calculate into weeks?

MayilVahanan — Wed, 19 Sep 2012 13:01:06 GMT

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

Wed, 19 Sep 2012 13:36:48 GMT

Thats great thank you.