Multiple Variables

evansabres — Thu, 19 Mar 2015 15:36:10 GMT

Hello -

I have a field, '[Buyer Type Code]'

I want to do a sum of quantity of tickets sold for [Buyer Type Code] where [Buyer Type Code] is not equal to several variables. The variables I want to include are 'STH' 'COMP' and 'EMPCOMP'

How do I enter an expression to have a sum not equal multiple variables.

Currently, I have

=SUM({<[prmBUYERTYPE]-={'STH'}>} prmTIXQTY)

to return all values not 'STH'. So, I just want to include two variables (any maybe more down the line)

Thank you

Re: Multiple Variables

maxgro — Thu, 19 Mar 2015 15:45:36 GMT

=SUM({<[prmBUYERTYPE]-={'STH', 'COMP'}>} prmTIXQTY)

topic Multiple Variables in QlikView

Multiple Variables

Re: Multiple Variables