topic Re: Where in QlikView

Where

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

HI ALl

I am trying to acheiev in the script by using this match functionlity and when i reload it gives me the error

where match([Scheduled for Release],'17.1','17.2','17.3','17.4','17.5','17.6','17.7','17.8','17.9',,'17.10','17.11','17.12');

Can someone suggest me on this

zhadrakas — Tue, 01 Aug 2017 08:09:19 GMT

where match([Scheduled for Release],'17.1','17.2','17.3','17.4','17.5','17.6','17.7','17.8','17.9'

'17.10','17.11','17.12');

try to remove one of the red commas

arvind_patil — Tue, 01 Aug 2017 08:12:38 GMT

Hi John,

Please Try Below:

where match([Scheduled for Release],'17.1','17.2','17.3','17.4','17.5','17.6','17.7','17.8','17.9','17.10','17.11','17.12');

Thanks,

Arvind Patil

Chanty4u — Tue, 01 Aug 2017 08:58:45 GMT

try this as Arvind Patil suggested,

But u feel still the error it is the issue with the case sensitive of the filed " Scheduled for Release" check for the gaps and case

where match([Scheduled for Release],'17.1','17.2','17.3','17.4','17.5','17.6','17.7','17.8','17.9','17.10','17.11','17.12');

ramasaisaksoft — Tue, 01 Aug 2017 09:30:40 GMT

Hi John,

unfortunately you type one more [ , ] after the value

match([Scheduled for Release],'17.1','17.2','17.3','17.4','17.5','17.6','17.7','17.8','17.9',,'17.10','17.11','17.12');

so remove one coma and check.