topic Displaying greater than Avg datas in QlikView

Displaying greater than Avg datas

Wed, 16 Jan 2013 11:15:02 GMT

Dear Experts,

I want to draw a pie chart that just includes some values which are greater than average of Sum(Qty)

Dimensions : Product

Expressions : Sum(Qty)

I am writing : =numavg(Sum(Qty)) in "Show only Values that are" box on "Dimensions Limits Tab" but nothing..

Any idea plase

Best Regards

lironbaram — Wed, 16 Jan 2013 11:22:37 GMT

have a look at the attach file

i think it does what you asked for

Wed, 16 Jan 2013 12:05:36 GMT

Dear Liron Baram,

I thank you for quick help.. When I inspect your answer it works... But i cant solve my problem...

I am attaching a sample to my message can you help me please

Best Regards

lironbaram — Wed, 16 Jan 2013 12:27:13 GMT

hi all you had to do is change in the dimension limit last list box from 'relative to total' to 'excat amount'

attach is your file

i also change the average function to

=aggr(sum(QTY),Product) which calulte the avg the products totals

the former function calculated the avg of QTY value

Wed, 16 Jan 2013 13:55:26 GMT

Dear Liron Baram..

I thank you

=avg(aggr(sum(QTY),Product)) is right solution and it solved my problem...

Best Regards