Normal Distribution

Fri, 22 May 2009 03:07:35 GMT

Hi All,

I am looking for a Normal Distribution chart (Bell Chart), preferably I want to see the year on year normal distributions. If some one has one please let me know. Alternatively please can you have a look at my aggr problem using set analysis. It has made me somewhat AGGR [:@]

I have a solution for a single selection and can get the graph if I set the reference, however have struggled to get it working for a second or third year using set analysis. The problem is in my aggr function

avg(aggr(sum({$<Year = {$(=max(Year)-1)}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>}

Donation.ber_amountgross*(DonationFundAllocation.ber_percentage/100)),

count(Donation.ber_donationid)))

this is the fumula that works for the present year

avg(aggr(sum({$<Year = {$(=max(Year))}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>}

Donation.ber_amountgross*(DonationFundAllocation.ber_percentage/100)),

Donation.ber_donationid))

I know the problem is aggr part and not sure what to do with DonationFundAllocation.ber_donationid I have tried using count.

Hope some one can help,

Neil

topic Normal Distribution in QlikView

Normal Distribution