topic Re: Where Condition in QlikView

Where Condition

upaliwije — Thu, 12 Jun 2014 07:20:17 GMT

Hi Friends

WHERE BRA_CODE =('AL00' 'AP00' 'AA00')

When I load data I have added the above where clause in my sql. But it is not working . Pls correct me

its_anandrjs — Thu, 12 Jun 2014 07:23:30 GMT

Try with

WHERE Match(BRA_CODE,'AL00','AP00','AA00')

and what is your complete SQL script let me know

jagan — Thu, 12 Jun 2014 07:24:36 GMT

Hi,

Use In

WHERE BRA_CODE IN ('AL00' 'AP00' 'AA00')

Regarsd,

Jagan.

rbecher — Thu, 12 Jun 2014 07:25:36 GMT

WHERE BRA_CODE IN ('AL00', 'AP00', 'AA00')

jagan — Thu, 12 Jun 2014 07:25:43 GMT

Hi,

If you want to use in Qlikview Script then try like this

WHERE Match(BRA_CODE, 'AL00' 'AP00' 'AA00')

Regards,

Jagan.

rbecher — Thu, 12 Jun 2014 07:48:40 GMT

..would be much better to use the Where Clause on SQL level than LOAD level! This prevents a lot of traffic from the database to QlikView.