topic invalid relational operator in QlikView

invalid relational operator

Fri, 12 Jul 2013 06:56:18 GMT

Hi,

I try to load data with some specific formula, my code is as below, but I receive an error message "invalid relational operator":

LOAD

VALID_FROM,

VALID_TO,

SQL SELECT

VALID_FROM,

VALID_TO,

FROM table

where A='A'

and B='B'

and not isnull("VALID_FROM")

and "VALID_TO">"VALID_FROM" or isnull("VALID_TO")

and isnull(E);

Is there naything wrong with the formula?

Peter

Re: invalid relational operator

Sokkorn — Fri, 12 Jul 2013 07:04:16 GMT

Hi Peter

Let try this way

LOAD
    A,
    B,
    C,
    D,
    VALID_FROM,
    VALID_TO,
    E Where A='A' and B='B' and Not IsNull([VALID_FROM]) and ([VALID_TO]>[VALID_FROM] or IsNull([VALID_TO])) and IsNull(E);
SQL SELECT
    A, 
    B,
    C,
    D,
    VALID_FROM,
    VALID_TO,
    E
FROM DAREO."ITEM_SU_T";

Re: invalid relational operator

Fri, 12 Jul 2013 07:19:54 GMT

try this

LOAD

VALID_FROM,

VALID_TO,

where A='A'

and B='B'

and not isnull("VALID_FROM")

and "VALID_TO">"VALID_FROM" or isnull("VALID_TO")

and isnull(E);

SQL SELECT

VALID_FROM,

VALID_TO,

FROM table;

Re: invalid relational operator

Fri, 12 Jul 2013 07:23:44 GMT

try this

LOAD

VALID_FROM,

VALID_TO,

where A='A' and B='B' and VALID_FROM <>' ' and num(VALID_TO) > num(VALID_FROM) or VALID_TO=' ' and E=' ';

SQL SELECT

VALID_FROM,

VALID_TO,

FROM table;

Re: invalid relational operator

er_mohit — Fri, 12 Jul 2013 07:47:32 GMT

Try this way

LOAD

VALID_FROM,

VALID_TO,

where A='A'

and B='B'

and [VALID_FROM]<>' '

and [VALID_TO]>[VALID_FROM] or isnull([VALID_TO])

and isnull(E);

SQL SELECT

VALID_FROM,

VALID_TO,

FROM table;

or this

LOAD

VALID_FROM,

VALID_TO,

where A='A'

and B='B'

and [VALID_FROM]<>' '

and [VALID_TO]>[VALID_FROM] or [VALID_TO]=' '

and E=' ';

SQL SELECT

VALID_FROM,

VALID_TO,

FROM table;

Re: invalid relational operator

Mon, 15 Jul 2013 01:21:43 GMT

Hi er.mohit,

Thanks but I'm afraid that I may have not made my formula clear, so the 'or' function doesn't work as I want, it loads into a lot of things that I don't need.

What I need to do is to apply the 'or' function only to [VALID_TO], meaning to load only if [VALID_TO] is null, if it's not null then load those [VALID_TO]>[VALID_FROM].

Is it possible to make that happen?

BR/Peter

Re: invalid relational operator

kaushiknsolanki — Mon, 15 Jul 2013 06:42:04 GMT

Hi,

Try below Script.

SQL SELECT

VALID_FROM,

VALID_TO,

FROM table

where A='A'

and B='B'

and not isnull(VALID_FROM)

and (VALID_TO>VALID_FROM or isnull(VALID_TO))

and isnull(E);

Regards,

Kaushik Solanki

Re: invalid relational operator

Mon, 15 Jul 2013 07:04:40 GMT

Hi try this..

SET SQL = “SELECT

VALID_FROM,

VALID_TO,

From Source table”;

LOAD
*; $(SQL) where
A='A' and B='B'

and not isnull(VALID_FROM)

and VALID_TO > VALID_FROM or isnull(VALID_TO)

and isnull(E);