topic Re: Set Analysis To exclude an item in QlikView

Set Analysis To exclude an item

Anonymous — Thu, 11 Apr 2013 00:35:32 GMT

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.

Re: Set Analysis To exclude an item

Thu, 11 Apr 2013 02:19:17 GMT

Using =- instead of <> should do the trick

Re: Set Analysis To exclude an item

Thu, 11 Apr 2013 02:37:10 GMT

Instead of <> try replacing it with -=

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

Re: Set Analysis To exclude an item

Thu, 11 Apr 2013 03:23:52 GMT

Hi,

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

try this

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

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

those two will trigger red underline but it will still work

Regards,

Alex

Re: Set Analysis To exclude an item

Anonymous — Thu, 11 Apr 2013 03:27:53 GMT

Try this way instead:

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

Re: Set Analysis To exclude an item

sibin_jacob — Thu, 11 Apr 2013 04:36:00 GMT

Try this one..

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

= 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

Re: Set Analysis To exclude an item

Thu, 11 Apr 2013 05:07:12 GMT

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

Re: Set Analysis To exclude an item

kogasawara — Thu, 11 Apr 2013 05:22:08 GMT

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'!!

Re: Set Analysis To exclude an item

Thu, 11 Apr 2013 05:25:45 GMT

Hi Cacostao,

Try This expression

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

if you have any doubt please find the below attachment

Regards,

Nirmal raj.

Re: Set Analysis To exclude an item

Eugeny_Ilyin — Thu, 11 Apr 2013 05:49:09 GMT

Hello,

Тry use -= instead of <>

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

Re: Set Analysis To exclude an item

deepakk — Thu, 11 Apr 2013 06:47:21 GMT

HI ,

This is not the correct method

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

Deepak

Re: Set Analysis To exclude an item

alexandros17 — Thu, 11 Apr 2013 07:00:25 GMT

try this

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

Re: Set Analysis To exclude an item

Anonymous — Thu, 11 Apr 2013 07:10:23 GMT

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

Re: Set Analysis To exclude an item

Thu, 11 Apr 2013 07:27:31 GMT

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

Re: Set Analysis To exclude an item

nilesh_gangurde — Thu, 11 Apr 2013 07:33:05 GMT

use below mentioned expression

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

-Nilesh

Re: Set Analysis To exclude an item

kumarnatarajan — Thu, 11 Apr 2013 07:59:45 GMT

Hi,

Try this one

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

Re: Set Analysis To exclude an item

marcohadiyanto — Thu, 11 Apr 2013 08:11:13 GMT

Hi Cacosta,

try with this :

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

it will show error line, but it works.

Regards

Re: Set Analysis To exclude an item

Thu, 11 Apr 2013 08:52:30 GMT

Try this

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

Re: Set Analysis To exclude an item

khadeer — Thu, 11 Apr 2013 09:11:56 GMT

Hi,

Try this

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

Re: Set Analysis To exclude an item

Thu, 11 Apr 2013 10:03:45 GMT

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.