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
Try this
= sum({$<ItemNO ={"*"}-{5126}>}[Total Value])
Let me know if it works.
Best Regards,
Gabriel
Using =- instead of <> should do the trick
Instead of <> try replacing it with -=
= sum({$<ItemNO-={'5126'}>}[Total Value])
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
Try this way instead:
= sum({$<ItemNO-={'5126'}>}[Total Value])
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
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
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'!!
Hi Cacostao,
Try This expression
= sum({1-$<ItemNO={'5126'}>}[Total Value])
if you have any doubt please find the below attachment
Regards,
Nirmal raj.
Hello,
Тry use -= instead of <>
= sum({$<ItemNO-={'5126'}>}[Total Value])