topic how to exclude a value in QlikView

how to exclude a value

Thu, 13 Feb 2014 00:36:42 GMT

I have a field which has certain values like so :

TYPE = { dev, prod, test}

How can I exclude only test from this field in my template?

Re: how to exclude a value

iktrayanov — Thu, 13 Feb 2014 00:50:03 GMT

Use expression like

if(match(TYPE,'dev','prod'),TYPE)

Regards,

Ivan

Re: how to exclude a value

Thu, 13 Feb 2014 00:58:34 GMT

Thanks.. but there are more values in the field than what I have given above around 15 of them and I have to exclude just 'test' it would be easier if there was a function just to exclude the value 'test'

Re: how to exclude a value

Alejandro_Hernández — Thu, 13 Feb 2014 01:00:42 GMT

SUM({<TYPE-={'test'}>} Value)

Re: how to exclude a value

iktrayanov — Thu, 13 Feb 2014 01:09:12 GMT

If (TYPE <> 'test', TYPE)

Re: how to exclude a value

Thu, 13 Feb 2014 01:10:23 GMT

Thank you