Set Analysis To exclude an item

[Anonymous]

Hello!  What's wrong with my formula ...I need to sum all the Total Value of the field Item NO but to exlcude item '5126'...but seems the <> doesn't work...

= sum({$<ItemNO<>{'5126'}>}[Total Value])

I  really appreciate if you could help me with this problem...I'm still a newbie in Qlikview.

Tks.

[#2]

Using =- instead of <> should do the trick

[#3]

Instead of <> try replacing it with -=

= sum({$<ItemNO-={'5126'}>}[Total Value])

[#4]

Hi,

you can't use <> inside set analysis^^

try this

sum({$<ItemNO -= {5126}>}[Total Value])

OR

sum({$<ItemNO = {*}-{5126}>}[Total Value])

those two will trigger red underline but it will still work

Regards,

Alex

[Anonymous]

Try this way instead:

= sum({$<ItemNO-={'5126'}>}[Total Value])

[sibin_jacob]

Try this one..

= sum({$<ItemNO-={'5126'}>}[Total Value])

or

= sum({$<ItemNO-={5126}>}[Total Value])

in expression window, It will show underlined with red color but you will get the right result.

Let me know if you a have any concerns/issues

Thanks,

Sibin Jacob

[#7]

Hi Cacostao,

Try This expression

= sum({1-$<ItemNO={'5126'}>}[Total Value])

if you have any doubt please find the below attachment

Regards,

Nirmal raj.

Message was edited by: nirmal.j

[kogasawara]

hi

im japanese!! thats why i can't explain well in english...sorry

but you can try this expression!!

--------------------------------------------------------------------

= sum({$<ItemNO={'*'}-{'5127'}>}[Total Value])

--------------------------------------------------------------------

'*' is all of ItemNO!!

the expression means all of ItemNO minus '5127'!!

[#9]

Hi Cacostao,

Try This expression

= sum({1-$<ItemNO={'5126'}>}[Total Value])

if you have any doubt please find the below attachment

Regards,

Nirmal raj.

[Eugeny_Ilyin]

Hello,

Тry use  -= instead of  <>

= sum({$<ItemNO-={'5126'}>}[Total Value])