topic Pivot table in QlikView

Pivot table

Mon, 05 Mar 2012 19:57:11 GMT

i need a report in that form:

			W1			W2			Wn
GLOBAL	GLOBAL	GLOBAL	sum(Invoices)	sum(receipts)	sum(invoices due)	sum(Invoices)	sum(receipts)	sum(invoices due)	sum(Invoices)	sum(receipts)	sum(invoices due)

I have date of invoices and week dimension create over that, and term of pay so i can find due date.

how to fit the due date if it is in another week?

rahulgupta — Tue, 06 Mar 2012 09:52:51 GMT

Hey

Please clarify your issue....

Tue, 06 Mar 2012 11:38:51 GMT

Date of invoice (dataInv) : 01.02.2012 - week(DataInv) = 5, value = 100

Due date (Ddate) : 15.02.2012 - week(DataInv) = 7

Pay date : 20.02.2012 - week(DataInv) = 8

In that case i should have:

5			6			7			8
100	0	0	0	0	0	0	0	100	0	100	0