Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

Expression

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

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

I think this is correct:

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

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
MK_QSL
MVP
MVP

Can you provide sample data?

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

I think this is correct:

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

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
NavinReddy
Creator II
Creator II
Author

Thanks you so much its working

thanks for quick help