topic Re: separate values between invoice date and order date in QlikView

separate values between invoice date and order date

Fri, 09 Jan 2015 15:59:21 GMT

Hi a new problem for me

i have a pivot table

dimension: itemID

expression1: sum(ORDERlinemaount)

expression2 sum(invoicesalesbalance)

there are two tables

1table: here are my orders with the salesid and the order date sorted by salesid and itemid

2table here are the invoices with the same salesid but the invoices are not sorted by the itemid only the summary of a salesid

i made a mastercalendar for the invoicedate and the orderdate

how can i realize that when i select in the master invoicedate the values for the invoicedate are independent from the selection of the orderdate (values)

Re: separate values between invoice date and order date

Fri, 09 Jan 2015 16:06:18 GMT

Could please provide the table or data for more clarity on the issue.

Re: separate values between invoice date and order date

chrismarlow — Fri, 09 Jan 2015 16:44:00 GMT

If your model is associating wouldn't you need 2 (disconnected from each other) calendars? So simplified;