topic Re: Where condition in QlikView

Where condition

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

HI All,

Iam trying to use Where condition , by using * but this is giving an error when reloading ..

can some one please correct my script ..

Resident TableA

where match(Code,'18.6*','18.7*','18.8*',18.9*,18.10*',18.11*');

Thanks in advance

sunny_talwar — Tue, 21 Aug 2018 11:08:35 GMT

I think you are missing few single quote

Resident TableA

Where WildMatch(Code, '18.6*', '18.7*', '18.8*', '18.9*, '18.10*', '18.11*');

Making a change to my response based on Pooja's response below.

pooja_prabhu_n — Tue, 21 Aug 2018 11:13:57 GMT

Hi,

Try wildmatch instead of Match

where WildMatch(Code,'18.6*','18.7*','18.8*','18.9*','18.10*','18.11*')

Thanks,

Pooja

sunny_talwar — Tue, 21 Aug 2018 11:16:14 GMT

That's true too