Set analysis using -=

[#1]

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

[#2]

try this symbol

<> instead of -=

[#3]

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

with regards

Harshita Gaur

[#4]

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

[anbu1984]

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

Are you getting correct result for your expression?

[#6 · Accepted solution]

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

[#7]

Thanks Martin for your reply, i got it working.

With Regards

Harshita Gaur