Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to exclude information from my totals in a chart. I want to set up a set analysis, stating if the field is not equal to ___ than sum the total cost. It does not like the not equal to symbols...
sum({<Agent#<>{"55555555,54444444,53333333,52222222,51111111"}>} Total)
Thank you,
Venus
Perhaps this?
sum({<Agent#-={55555555,54444444,53333333,52222222,51111111}>} Total)
Sum ( {$< Agent# -= {'55555555,54444444,53333333,52222222,51111111''}>} Total )
(would be the correct syntax I believe.. therefore the 'not equal to' would be '-=')
NOTE: QlikView 10 actually reports this as a bad syntax portion (underlines in red) yet will report "Expression OK" and work properly.
Best,
Jared
Thank you, John! It worked.
Thank you, Jared. I appreciate the fast response time.
Venus