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.

[deepakk]

HI ,

This is not the correct method

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

Deepak

[alexandros17]

try this

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

[Anonymous]

Just some modification needed

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

That is use - = in your set analysis and you are using '5126' that is you are passing a string checking to item no which is wrong

Regards,

Anant

[#5]

Hi Qlikview family,

this is bharat,just i am looking some real time scenarios that is compatible to qlikview personal edition,

  some body send me any real time scenarios that is help to me to introduce qlikview family,,,

    Thanks & Regards,

    Bhargav

[nilesh_gangurde]

use below mentioned expression

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

-Nilesh

[kumarnatarajan]

Hi,

Try this one

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

[marcohadiyanto]

Hi Cacosta,

try with this :

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

it will show error line, but it works.

Regards

[#9]

Try this

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

[khadeer]

Hi,

Try this

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

[#11]

Hello,

The syntax to exclude values in a set analysis is not '<>' but ' -='.

So try this formula :

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

Your formula will appear in 'Error', it is a problem with V11 but the result should be OK.