Ageing Debt using a Variable

Wed, 12 Jun 2013 10:58:58 GMT

Hi All

I have created a variable (vDate) in which I can enter a specific date, i.e. the last date of the current month, in an effort to forecast my debt ageing as at that date into a number of categories.

I have then entered the below into the script however everything is being returned as being in the category "Greater than 120 Days", where am I going wrong?

thanks in advance

Iain

     IF(('vDate' - [CLE.Document Date])<=30,'0 - 30 Days',

     IF(('vDate' - [CLE.Document Date])<=60,'31 - 60 Days',

     IF(('vDate' - [CLE.Document Date])<=90,'61 - 90 Days',

     IF(('vDate' - [CLE.Document Date])<=120,'91 - 120 Days','Greater Than 120 Days')))) as [CLE.InvoiceAged Band Variable],

Re: Ageing Debt using a Variable

Gysbert_Wassenaar — Wed, 12 Jun 2013 11:27:27 GMT

You're using a literal string: 'vDate' . Try vDate without the quotes or $(vDate). Make sure vDate contains a real date and not a string or you won't get a number of days back when you subtract CLE.Document Date from it.

topic Ageing Debt using a Variable in QlikView

Ageing Debt using a Variable

Re: Ageing Debt using a Variable