topic Re: Calculate average between two fields in QlikView

Calculate average between two fields

Tue, 20 May 2014 19:34:06 GMT

Guys,

I have to calculate an average of Ticket Price.

Formula will be - Sum ( Total Base Fare Amount ) / Sum ( Ticket Count)

My question is how can i achieve this QlickView ?

Please Help !

Thanks,

its_anandrjs — Tue, 20 May 2014 19:40:37 GMT

For this write expression like

=Sum (Total [Your Base Fare Amount Field Here] ) / Count (Distinct [Ticket Field Name])

=Sum (Total [Your Base Fare Amount Field Here] ) / Count ([Ticket Field Name])

if you have sample then provide.