topic how to use isnull in expression in QlikView

how to use isnull in expression

Thu, 25 Sep 2014 07:15:57 GMT

Hi,

how to use isnull in expression?

Re: how to use isnull in expression

CELAMBARASAN — Thu, 25 Sep 2014 07:18:54 GMT

IsNull(expr )

Returns -1 (true) if expr returns NULL, otherwise 0 (false).

Use IsNull(FieldName) will return true if it is null

Re: how to use isnull in expression

ashfaq_haseeb — Thu, 25 Sep 2014 07:19:54 GMT

What are you trying to achieve.

Can you post your application

You can use like this

If(RowNo() = 0 or IsNull(RowNo()),Sum(Sales)

regards

ASHFAQ

Re: how to use isnull in expression

Thu, 25 Sep 2014 07:24:56 GMT

In set analysis How to write isnull

eg.I want to use isnull for profitCent,But How to use in this expression.

num(sum({<PODate = {'>=$(=Date(MonthStart(min(CalenderDate)))) <=$(=Date(max(CalenderDate)))'} >} Amt))

Re: how to use isnull in expression

amit_saini — Thu, 25 Sep 2014 07:28:21 GMT

Amol,

Below are few examples:

1. IF(ISNULL(ItemName)=0, ItemName, '001' ) AS ItemName

2.If( Len(Trim(Field))=0 or Isnull(Field) , this, that) as FieldName

3. =If( if(Year<>2013,avg([Act % of Rev.]),(Sum([Act. Scrap $])/sum([Act Revenue])))<>0,

if(Year<>2013,avg([Act % of Rev.]),(Sum([Act. Scrap $])/sum([Act Revenue]))),

null()

)

Thanks,

Re: how to use isnull in expression

ashfaq_haseeb — Thu, 25 Sep 2014 07:30:49 GMT

Considering profitCent is valid field.

Try like below

num(sum({<PODate = {'>=$(=Date(MonthStart(min(CalenderDate)))) <=$(=Date(max(CalenderDate)))'},profitCent={''}>} Amt))

Regards

ASHFAQ

Re: how to use isnull in expression

Thu, 25 Sep 2014 08:23:46 GMT

How to use isnull in given example

Re: how to use isnull in expression

ashfaq_haseeb — Thu, 25 Sep 2014 08:25:41 GMT

No Attachment

regards

ASHFAQ

Re: how to use isnull in expression

anbu1984 — Thu, 25 Sep 2014 10:48:51 GMT

Try

num(sum({<PODate = {'>=$(=Date(MonthStart(min(CalenderDate)))) <=$(=Date(max(CalenderDate)))'},

Amt={'=Len(Trim(profitCent))=0'}>} Amt))

num(sum({<PODate = {'>=$(=Date(MonthStart(min(CalenderDate)))) <=$(=Date(max(CalenderDate)))'},

Amt={'=NullCount(profitCent)>0'}>} Amt))