topic Re: IF Statement in QlikView

IF Statement

Anonymous — Wed, 02 Mar 2016 14:43:36 GMT

Hi All

How can i do the following in the script?

if TransType = '11','12','13' TransType

so i only want data from the table if TransType is 11, 12 13

Thanks

sunny_talwar — Wed, 02 Mar 2016 14:44:43 GMT

May be use Where Statement:

LOAD FieldName

FROM Table

Where Match(TransType, 11, 12, 13);

alexandros17 — Wed, 02 Mar 2016 14:45:41 GMT

In the where condition :

Where ... Wildmatch([TransType], '11','12','13') > 0

Anonymous — Wed, 02 Mar 2016 14:46:11 GMT

....Again Thanks!!!

puttemans — Wed, 02 Mar 2016 14:46:50 GMT

IF(TransType > 10 and TransType < 14, DO SOMETHING)

sunny_talwar — Wed, 02 Mar 2016 14:53:34 GMT

No problem