Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
cacosta35
Creator II
Creator II

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
Gabriel
Partner
Partner

Hi

Try this

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

Let me know if it works.

Best Regards,

Gabriel

View solution in original post

29 Replies
Not applicable

Using =- instead of <> should do the trick

Not applicable

Instead of <> try replacing it with -=

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

Not applicable

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

jsn
Master
Master

Try this way instead:

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

sibin_jacob
Creator III
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

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
Partner
Partner

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

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
Creator II
Creator II

Hello,

Тry use  -= instead of  <>

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