Announcements
cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Set Analysis To exclude an item

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.

1 Solution

Accepted Solutions
Partner - Specialist III

Hi

Try this

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

Let me know if it works.

Best Regards,

Gabriel

29 Replies
Not applicable
Author

Using =- instead of <> should do the trick

Not applicable
Author

Instead of <> try replacing it with -=

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

Not applicable
Author

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
Not applicable
Author

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

Creator III

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

Not applicable
Author

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

Partner - Creator

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

Not applicable
Author

Hi Cacostao,

Try This expression

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

if you have any doubt please find the below attachment

Regards,

Nirmal raj.

Creator II

Hello,

Тry use  -= instead of  <>

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

Community Browser