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]

Hi

I am new to QlikView so this could be wrong..

Does this do what you need?

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

If it does; the important part of the formula is the minus symbol after the $ dollar sign (a Modifier).  I also think the greater/less than combo fail as they look like the set analysis brackets.

I hope this helps.

Oli

[Eugeny_Ilyin]

Hello,

Try use -= instead of <>

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

[jagan]

Hi,

Try like this

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

-= should be used to exclude the items, qlikview will show error near -=, but works as expected.

Hope this helps you.

Regards,

Jagan.

[#5]

Hi,

You can replace the <> with -= like this:

Sum({$<ItemNO -= {'5126'}>} [Total Value]) //can be also {$<ItemNO = ItemNO - {'5126'}>}

Hope this helps.

[johnca]

Try this;

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

or

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

Note the minus-equal signs for does not equal.

[datanibbler]

Hi,

I am a newbie myself - and, to be honest, I'm not familiar with the syntax as you use it yet - but wouldn't it work if you turn it "inside out", writing

IF(ItemNO<>5126,sum([Total Value])

?

(I don't think you need to enclose a number in quotes, that's only for STRINGs)

HTH

Regards,

DataNibbler

[eddysanchez]

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

[Gabriel · Accepted solution]

Hi

Try this

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

Let me know if it works.

Best Regards,

Gabriel

[Anonymous]

Thanks everyone for your contributions ... I couldn't imagine there are actually no of ways to solve my problem .... Using =- or -=  instead of <> actually works though it gives me  red error lines.  Thus, I'm confident to use below formula...

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

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

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

I wish I could flag more  correct answers 🙂

[fabio182]

Thanks man