Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hello,
Try use -= instead of <>
= sum({$<ItemNO-={'5126'}>}[Total Value])
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.
Hi,
You can replace the <> with -= like this:
Sum({$<ItemNO -= {'5126'}>} [Total Value]) //can be also {$<ItemNO = ItemNO - {'5126'}>}
Hope this helps.
Try this;
Sum ({$<ItemNO-={5126}>} [Total Value])
or
Sum ({$<ItemNO-={'5126'}>} [Total Value])
Note the minus-equal signs for does not equal.
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
sum({$<ItemNO={">5126<5126"}>}[Total Value])
Hi
Try this
= sum({$<ItemNO ={"*"}-{5126}>}[Total Value])
Let me know if it works.
Best Regards,
Gabriel
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 🙂
Thanks man