topic Average formula issue in QlikView

Average formula issue

raghavsurya — Thu, 24 Mar 2011 10:58:58 GMT

Hi All,

We have situation where in we need to ignore any negetive / zero values in the table and calculate the average or Min or Max values. For Example

The Average formula should ignore product b and product e which calculating average. Can anybody suggest how to do this.

Regards,

Raghav

Thu, 24 Mar 2011 11:12:44 GMT

For example:

AVG(IF(Profit>0,Profit))

raghavsurya — Thu, 24 Mar 2011 11:23:01 GMT

Hi,

In the same scenario, if we want to select minimum of the values how should we put the formula. Can you please help us.

Regards,

Raghav

Thu, 24 Mar 2011 11:29:29 GMT

Just change the AVG function to MIN.