topic Re: Expression in QlikView

Expression

NavinReddy — Tue, 22 Apr 2014 15:03:54 GMT

Dear All,

i am calculating AVG for this Expression

=round(sum(pay_amount)/count(Distinct[standard id])) =100

its working fine But i want to calculate Month Wise ,i want to put one more filter

I am using this expression its not working

=round(avg(aggr(sum(pay_amount), [standard id],month)))=15

is it correct way or correct

But i want to calculate Distinct Standard Id like this

=round(avg(aggr(sum(pay_amount),Count(Distinct [standard id]),month)))

its not working please some one help me

i am struck here any help

Thanks in Advance

Niranjan

MK_QSL — Tue, 22 Apr 2014 15:05:56 GMT

Can you provide sample data?

jonathandienst — Tue, 22 Apr 2014 15:12:15 GMT

I think this is correct:

round(avg(aggr(sum(pay_amount) / count(Distinct [standard id]), month)))

HTH

Jonathan

NavinReddy — Tue, 22 Apr 2014 15:21:58 GMT

Thanks you so much its working

thanks for quick help