topic Cleaner WHERE Clause in QlikView

Cleaner WHERE Clause

Wed, 31 Oct 2012 14:12:38 GMT

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

MayilVahanan — Wed, 31 Oct 2012 14:15:33 GMT

Try like this

Load *;

From TableA

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

Hope it helps

jagan — Wed, 31 Oct 2012 14:31:55 GMT

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.