topic Re: using set expression to exclude a value in QlikView

using set expression to exclude a value

Anonymous — Thu, 02 Jul 2015 17:55:21 GMT

Hi,

I was trying to create a set expression like {<Brands<>{'Total'}>}. But it seems that QlikView doesn't allow '<>' in a set expression.

So how is it possible to exclude a value by the means of a set expression?

Thank you in advance,

Larisa

Anonymous — Thu, 02 Jul 2015 17:59:09 GMT

{<Brands-={'Total'}>}

Qrishna — Thu, 02 Jul 2015 18:04:11 GMT

{<Brands= {"*">} - {'Total'}>} or {<Brands - = {'Total'}>}. should do

Anonymous — Thu, 02 Jul 2015 18:04:29 GMT

Thank you!