Ageing Category Expression Assistance

Tue, 16 Apr 2013 11:44:30 GMT

Hi, trying to do an IF statement as an expression to categorise invoices by age into ageing categories 1-30, 31 - 60 etc, the below is returning a result of all 120 + Days which I take it is because for categories 31 + I am just saying <61, <91 rather than >30 and < 61, >90 and < 121, but how would this be written to get the right result?

If (num(Today())-Num(InvoiceAge)<31,'1-30 Days',IF(num(Today())-Num(InvoiceAge)<61,'31-60 Days',IF(num(Today())-Num(InvoiceAge)<91,'61-90 Days',IF(num(Today())-Num(InvoiceAge

)<121,'90-120 Days','120 + Days'))))

Thanks

Roger

Re: Ageing Category Expression Assistance

Gysbert_Wassenaar — Tue, 16 Apr 2013 13:41:32 GMT

Today() returns a date. If InvoiceAge isn't a date but a number than subtracting it from today() would return a date. That numeric value of that date will almost certainly be larger than 120.

If InvoiceAge is a date you'll have to post a file with some data we can look at.

topic Ageing Category Expression Assistance in QlikView

Ageing Category Expression Assistance

Re: Ageing Category Expression Assistance