topic Account Ageing in QlikView

Account Ageing

Tue, 16 Jun 2009 07:40:23 GMT

Hello,

I would like to do some ageing 30, 60, 90+.

I created a script with a where clause which looked similar to the following:

LOAD fields

SQL SELECT fields

FROM

WHERE field Date BETWEEN addmonths(today(),-1) and today();

This however doesn't work, it doesn't recognise the functions. I then created a variable and included it into the WHERE clause but this didn't work either. Any help to this problem would be cool.

Account Ageing

Anonymous — Tue, 16 Jun 2009 07:54:31 GMT

John,
You're makinga a typical mistake trying to use QV functions (in this case addmonths and today) in SQL SELECT. You can use QV functions only in LOAD. For example:


LOAD
...
WHERE Date>=addmonths(today(), -1) and Date<=today();
SQL SELCT
...
FROM ;

Account Ageing

Wed, 17 Jun 2009 08:13:24 GMT

Thanks mate, works