topic Re: Filter multiple values in script in QlikView

Filter multiple values in script

Anonymous — Thu, 12 May 2016 06:23:17 GMT

Hi All,

I am looking filter multiple values in script, i tried using Where [Employment Status]='Permanent' and 'Contract'

Where [Employment Status]='Permanent'and [Employment Status]='Contract'

Where [Employment Status] in (Permanent','Contract')

Where match( [Employment Status] , Permanent','Contract')

what will be the correct syntax?

Thanks,

Krishna

Kushal_Chawda — Thu, 12 May 2016 06:24:44 GMT

Where match( [Employment Status] , 'Permanent','Contract')

Filter values are case sensitive so make sure that Filter Values matching with actual data

MK_QSL — Thu, 12 May 2016 06:26:25 GMT

Where Match(FieldName,'FirstValue', 'SecondValue', 'ThirdValue');

Kushal_Chawda — Thu, 12 May 2016 06:36:06 GMT

krishna4bo‌ was that not working which I have suggested?

MK_QSL — Thu, 12 May 2016 07:44:43 GMT

krishna4bo‌ You should have marked kush141087‌'s answer correct and my answer as helpful. He has replied before me.