topic Re: Isnull() function in Pivot table in QlikView

Isnull() function in Pivot table

muniyandi — Fri, 10 Oct 2014 07:48:05 GMT

Hi All,

I'm using pivot table, my requirement is monthwise sales .if currect month sales is zero or null means, to carry last month sales.

if(Column(1)=0,Before(Column(1)),sum(sales)) /*Working Correctly */

But:

if(isnull(column(1)),Before(Column(1)),sum(sales)) /* Not Working */

What's the reason using isnll() function entire row getting null ?

Required Expression :

if(( isnull(column(1)) or Column(1)=0),Before(Column(1)),sum(sales))

Thanks,

Muni

Re: Isnull() function in Pivot table

muniyandi — Fri, 10 Oct 2014 08:11:08 GMT

hi ,

anybody help to me

Re: Isnull() function in Pivot table

Anonymous — Fri, 10 Oct 2014 08:15:59 GMT

HI,

with column() you are adressing the content of your current row for the specified column. Depending on your expression in Column 1 it will not return null even if data is null. For example sum always returns 0, even if you sum null values. This maybe the reason why isnull() will not work on column(1).

Best

Stefan

Re: Isnull() function in Pivot table

muniyandi — Fri, 10 Oct 2014 09:04:55 GMT

Hi Stefan,

Thanks For reply,

My data have null value , how to deal null and zero values. in my expression .

Re: Isnull() function in Pivot table

Fri, 10 Oct 2014 09:17:50 GMT

try this

if(( column(1)=null() or Column(1)=0),Before(Column(1)),sum(sales))