topic Re: null values in QlikView

null values

Fri, 24 Apr 2015 15:49:11 GMT

hi experts,

i have the following set analysis expression for calculating a field in a pivot table.

Expression:

=Num(Avg(Aggr(

Count({<CalendarDate=, CalendarMonthYear= {">=$(=date(MonthStart(Max(CalendarDate))))<=$(=date(Max(CalendarDate)))"}>} Unanswered)

(Sum({<CalendarDate=, CalendarMonthYear= {">=$(=date(MonthStart(Max(CalendarDate))))<=$(=date(Max(CalendarDate)))"}>} Answered)

Sum({<CalendarDate=, CalendarMonthYear= {">=$(=date(MonthStart(Max(CalendarDate))))<=$(=date(Max(CalendarDate)))"}>} Unanswered))

,branchname)))

i m getting some null values in some rows. because of this null value, the next field which depends on this field also gets null value.

so, i want to show the null values as zero value.

How can i do that.

please give me suggestions.

buzzy996 — Fri, 24 Apr 2015 15:53:22 GMT

select ur expression and try this

Gabriel — Fri, 24 Apr 2015 15:55:12 GMT

Hi,

I would just wrap all the expression inside IF(ISNULL())

Fri, 24 Apr 2015 16:09:17 GMT

hi Gabriel,

thanks for the reply.

i tried this, but its not working.

can u please help me with the complete expression?

Fri, 24 Apr 2015 16:15:22 GMT

Hi,

maybe wrap your expression in a rangemax() function. That will ensure you have a value.

Rangemax(myexpressionhere,0)

hope that helps

Joe

Fri, 24 Apr 2015 16:39:31 GMT

thanks a lot joe

Mon, 27 Apr 2015 07:46:22 GMT

no problem glad to help