topic Re: If in script in QlikView

If in script

Fri, 16 May 2014 09:43:35 GMT

Hi,

I want to use IF in my script to determine a field "JoursLitige" which depends on others fields so I did like this but I have an error "Error in expression: ')' expected"

LOAD ID,

DateFacture ,

Today() - DateFacture as DépassementLitige,

if ((DépassementLitige <= 30),'1',

if ((31 <= DépassementLitige <= 60), '2',

if ((61 <= DépassementLitige <= 90),'3', '4'))) as JoursLitige

FROM

[..\..\file.xls] (biff, embedded labels, table is A$);

Re: If in script

crusader_ — Fri, 16 May 2014 09:46:18 GMT

Hi,

You're not allowed use DépassementLitige inside same table LOAD.

To solve problem just use this one:

LOAD ID,

DateFacture ,

Today() - DateFacture as DépassementLitige,

if (((Today() - DateFacture) <= 30),'1',

if (((Today() - DateFacture) <= 60), '2',

if (((Today() - DateFacture) <= 90),'3', '4'))) as JoursLitige

FROM

[..\..\file.xls] (biff, embedded labels, table is A$);

Hope this helps.

Andrei

Re: If in script

anbu1984 — Fri, 16 May 2014 09:52:23 GMT

Load *,

if ((DépassementLitige <= 30),'1',

if ((DépassementLitige <= 60), '2',

if ((DépassementLitige <= 90),'3', '4'))) as JoursLitige;

LOAD ID,

DateFacture ,

Today() - DateFacture as DépassementLitige

FROM

[..\..\file.xls] (biff, embedded labels, table is A$);

Re: If in script

simondachstr — Fri, 16 May 2014 09:53:03 GMT

Use a preceding load:

LOAD *,

if ((DépassementLitige <= 30),'1',

if ((31 <= DépassementLitige <= 60), '2',

if ((61 <= DépassementLitige <= 90),'3', '4'))) as JoursLitige

;

LOAD ID,

DateFacture ,

Today() - DateFacture as DépassementLitige,

FROM

[..\..\file.xls] (biff, embedded labels, table is A$);

Re: If in script

simondachstr — Fri, 16 May 2014 09:53:24 GMT

You were faster

Re: If in script

Fri, 16 May 2014 09:57:24 GMT

hello,

you have missed two ')' of if function,and one more thing you have to 'AND' operation between two expression ,

your code should be like this

LOAD ID,

DateFacture ,

Today() - DateFacture as DépassementLitige,

if (((Today() - DateFacture) <= 30),'1',if ((31 <= (Today() - DateFacture) and (Today() - DateFacture) <= 60), '2',if ((61 <= (Today() - DateFacture) and (Today() - DateFacture)<= 90),'3', '4'))))) as JoursLitige

FROM

[..\..\file.xls] (biff, embedded labels, table is A$);

Re: If in script

crusader_ — Fri, 16 May 2014 10:02:02 GMT

31 <= (Today() - DateFacture)

(61 <= (Today() - DateFacture)

are excess conditions, because if your number not less or euqal 30 - it's definitely more or equal than 31

Andrei

Re: If in script

Fri, 16 May 2014 10:22:42 GMT

Thank you all! I solved the problem

Re: If in script

jagan — Fri, 16 May 2014 10:24:31 GMT

Hi,

Try like this

LOAD

if (DépassementLitige <= 30,'1',

if (DépassementLitige <= 60, '2',

if (DépassementLitige <= 90),'3', '4'))) as JoursLitige;

LOAD ID,

DateFacture ,

Today() - DateFacture as DépassementLitige

FROM

[..\..\file.xls] (biff, embedded labels, table is A$);

Hope this helps you.

Regards,

Jagan.