topic Re: Null() function in QlikView

Null() function

Anonymous — Wed, 27 Jun 2018 06:04:59 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.

sunny_talwar — Wed, 27 Jun 2018 15:35:35 GMT

May be this

Sum(sal)/Count(sal)

sunny_talwar — Wed, 27 Jun 2018 15:36:21 GMT

Sum(sal)/Count(DISTINCT Dimension)

Where Dimension is the field you are trying to average sal

BalaBhaskar_Qlik — Wed, 27 Jun 2018 16:50:38 GMT

Try like:

Sum(Sales)/(Count({<Date={'<=$(vMaxDate)'},Sales-={""}>} Sales))

Check the dates also.