topic Set analysis using -= in QlikView

Set analysis using -=

Tue, 18 Nov 2014 13:49:24 GMT

Hi,

I am using 'not equal to' condition in Qlikview set expression, while using -= in expression the remaining script will become garbage , and it stop giving the recommendation of field. can you please tell what is its reason?

With Regards

Harshita Gaur

Re: Set analysis using -=

Tue, 18 Nov 2014 13:52:49 GMT

try this symbol

<> instead of -=

Re: Set analysis using -=

Tue, 18 Nov 2014 13:56:10 GMT

This '<>' worked in if condition, but don't work in set expression

with regards

Harshita Gaur

Re: Set analysis using -=

Tue, 18 Nov 2014 14:00:39 GMT

Hi after reading in community i came to know that

-= its a bug

instead of that go for

=* -excluded ( * is all ) - which u dont want

Re: Set analysis using -=

anbu1984 — Tue, 18 Nov 2014 14:04:31 GMT

Red lines which you see in expression after you add -= in set analysis is a bug.

Are you getting correct result for your expression?

Re: Set analysis using -=

Tue, 18 Nov 2014 14:04:32 GMT

Hi Harshita,

I had the same problem yesterday. Instead of -= you can put - before < like this expression: =Sum({$ -<Type={O}> * <MutDescr={Revenue}>} Amount). So, in this case I want all Types except 'O', and (that's the *) where MutDescr is 'Revenue'.

Hope this will do it for you...

Martin

Re: Set analysis using -=

Tue, 18 Nov 2014 14:13:27 GMT

Thanks Martin for your reply, i got it working.

With Regards

Harshita Gaur