topic How to use isnull() in Set Analysis? in QlikView

How to use isnull() in Set Analysis?

Anonymous — Wed, 19 Jan 2011 06:11:41 GMT

I want to use "sum(if(isnull(Department)=0,Sales))", but how can I achieve by useing Set Analysis?

deepakk — Wed, 19 Jan 2011 07:37:28 GMT

hi,

You check the null condition in script. This will make the expression easy at reporting level.

If(isnull(Fieldname) =-1,'Y','N') as Indicator

at expr:

sum({<Indicator ={"Y"}>} Amount)

Anonymous — Wed, 19 Jan 2011 08:33:01 GMT

Thank you Deepak Kurup, but how can you achieve it without creating a new field "Indicator"?

sparur — Wed, 19 Jan 2011 09:26:51 GMT

Hello, John

try this:

sum({$<[Department]={"=Len(Department) = 0"}>} Sales)

sum({$<[Department]={""}>} Sales)

sorry, for you task it will be like this:

sum({$<[Department]={"=Len(Department) > 0"}>} Sales)

Anonymous — Wed, 19 Jan 2011 10:33:05 GMT

Thank you, sqarur.

Wed, 14 Dec 2011 14:43:56 GMT

I think the Len function only works when your value is not really a null, but an empty string.

The difference is subtle, but there IS a difference.