topic Re: Sum of a Particular Field in QlikView

Sum of a Particular Field

evansabres — Fri, 13 Mar 2015 16:35:23 GMT

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.

Re: Sum of a Particular Field

Fri, 13 Mar 2015 16:42:19 GMT

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

Re: Sum of a Particular Field

Fri, 13 Mar 2015 16:43:06 GMT

Maybe have a look at this

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

also, for more info and good examples on set analysis

Joe

Re: Sum of a Particular Field

MK_QSL — Fri, 13 Mar 2015 16:43:21 GMT

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