Slicer problem

Tue, 16 Apr 2013 07:29:36 GMT

I am preparing a Accounts payable forecast report. It is using existing purchase order and purchase requsitions from SAP. I am also taking agreed payment terms from vendor master. Quite often payments are not paid exactly on the agreed time; they can be paid few days early or late. My report should show how much we have open payments in becomming months (if invoice date is within the month or earlier and payment date is not within the month, report should show this value for this month).This I try to simulate with slicer function in my Qlikview report. However, something is not working properly. I have following script in my pivot table

sum({<Month={"<=$(=Max(Month))"},#PVM=>} If((#PVM+[Due date]+ vDueDateChange)>=MonthEndPVM And [Period in Month]<=Month, PO_value))

in where

"Month" is the forecast month
#PVM is the invoice date
"Due date" is the agreed payment term
vDueDateChange is the variable in slicer, days paid early/late
MonthEndPVM is the last day of the month
Period in Month is the month when payment is due
PO Value is the purchase order value

It looks like that if I said with slicer that I pay few days earlier it seems to change values, but If I would say that I paid late it gives the original value. Would someone know what is the problem in my script??

Thanks

Janne

topic Slicer problem in QlikView

Slicer problem