topic Re: Average Calculation excluding Negative Value and Zero in QlikView

Average Calculation excluding Negative Value and Zero

sachin08 — Wed, 09 Jan 2019 08:40:22 GMT

I have calculated Avg of sales with two way just i want to know which one is correct.

1) When i have calculated AVG of sales first time i took all the value with negative and Zero .

2) When i have calculated second time AVG of sales i have exclude the negative value and zero.

just i want to know which one is correct.

Also i have attached the excel and qvd. Kindly refer attached.

Re: Average Calculation excluding Negative Value and Zero

marcus_sommer — Wed, 09 Jan 2019 09:06:56 GMT

It depends on your requirements which calculation returns the expected values. Quite helpful for considering the right approach is the following: Average-Which-average

- Marcus

Re: Average Calculation excluding Negative Value and Zero

sachin08 — Wed, 09 Jan 2019 11:02:50 GMT

Should i exclude the negative value during Average calculation in script.

Re: Average Calculation excluding Negative Value and Zero

marcus_sommer — Wed, 09 Jan 2019 11:59:18 GMT

It's not a technically question else it depends on the business-logic if any values and if yes which ones should be excluded or not.

- Marcus