topic Re: Null() issue? in QlikView

Null() issue?

Mon, 09 Mar 2015 09:09:18 GMT

I have source application and target appliaction.while testing two applications the avg(Sal) is not coming correctly.

assume that in target some null values added extra compare to source.

so it will take avg means all the count of null values right?

how can i achieve it?

both sum(sal) is same value in source app and target app.

but Avg(sal) is not correct.

tresB — Mon, 09 Mar 2015 09:16:06 GMT

Avg() disregards null values. You have alternative to use to include them, try your own formula for the same like:

Sum(Amt)/ Count (yourDim)

chrislofthouse — Mon, 09 Mar 2015 09:16:33 GMT

Is this in the script or in a chart in the dashboard?

Mon, 09 Mar 2015 09:25:25 GMT

Hi,

In straight table i am using this expression like avg(Sal)

how cani achieve this if i have null values.the avg vl count the null value count also so

chrislofthouse — Mon, 09 Mar 2015 09:45:00 GMT

Are you positive it is nulls creeping into the calculation and not zero values, it would make more sense if it was the latter?

awhitfield — Mon, 09 Mar 2015 09:53:10 GMT

Hi Rakesh,

please see the attached example, is this what you require?

Andy