Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table

i need a report in that form:




W1W2Wn
GLOBALGLOBALGLOBALsum(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?

2 Replies
rahulgupta
Partner - Creator III
Partner - Creator III

Hey

Please clarify your issue....

Not applicable
Author

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:

5678
100000000010001000