Cleaner WHERE Clause

[#1]

Hi, 

My question is hopefully a basic one regarding having less script to get to the same thing.  Currently I am doing the following

Load *;

From TableA

WHERE OrderType = "A" AND OrderClass = 71

OR OrderType = "A" AND OrderClass = 85

OR OrderType = "A" AND OrderClass = 91;

Is there a simplier way to write this i.e. in SQL it would be something like

WHERE OrderType = 'A' AND OrderClass IN (71, 85, 91)

Many thanks

C

[MayilVahanan · Accepted solution]

HI

Try like this

Load *;

From TableA

WHERE OrderType = "A" and match(OrderClass,71,85,91)

Hope it helps

[jagan]

Hi,

Try like this

LOAD

     *

FROM TableA

WHERE OrderType = "A" AND Match(OrderClass, 71, 85, 91);

The match() in Qlikview will act similarly like In in SQL.  Also you have different variants of Match() like Mixmatch() and WildMatch().

Hope it helps you.

Regards,

Jagan.