Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
adil_hussain
Creator II
Creator 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
sunny_talwar

May be use Where Statement:

LOAD FieldName

FROM Table

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

View solution in original post

5 Replies
sunny_talwar

May be use Where Statement:

LOAD FieldName

FROM Table

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

alexandros17
Partner
Partner

In the where condition :

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

adil_hussain
Creator II
Creator II
Author

....Again Thanks!!!

puttemans
Specialist
Specialist

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

sunny_talwar

No problem