Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
adil_hussain
Contributor II

IF Statement

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

1 Solution

Accepted Solutions

Re: IF Statement

May be use Where Statement:

LOAD FieldName

FROM Table

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

View solution in original post

5 Replies

Re: IF Statement

May be use Where Statement:

LOAD FieldName

FROM Table

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

View solution in original post

Re: IF Statement

In the where condition :

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

adil_hussain
Contributor II

Re: IF Statement

....Again Thanks!!!

Highlighted
puttemans
Valued Contributor

Re: IF Statement

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

Re: IF Statement

No problem