Sum of a Particular Field

[evansabres]

Hello -

I have a data set for studying ticket sales. The field that is identified as 'Quantity' represents the number of tickets sold. Another field, called 'Buyer Type Code' represents the type of buyer (individual, season ticket holder, etc)

I want to create a chart where I sum the quantity of tickets sold where they buyer type code IS NOT a season ticket holder so as to identify the number of tickets purchased by anyone who is not a season ticket holder.

How do I go about formulating the equation?

Thank you.

[#2 · Accepted solution]

Hi Evan,

look to use set analysis for this, the below should work for you

Sum({<[Buyer Type Code]-={'season ticket holder'}>} Quantity)

hope that helps

Joe

[#3]

Maybe have a look at this

http://community.qlik.com/docs/DOC-4951

also, for more info and good examples on set analysis

Joe

[MK_QSL]

Provide few lines of sample data along with your expected output..