I would like to be able to calculate the sum of all invoices per week number for months.
Is QlikView able to calculate into weeks?
Try like this,
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
Thats great thank you.
Retrieving data ...