Isnull in set analysis

Fri, 01 Jul 2011 16:29:23 GMT

Hi All,

How do I write this following statement in set analysis,

sum(if(FACT_TYPE='Current' AND FLAG_HEALTH_REPORT='1' AND LINE_ITEM_STATUS='Design In' AND REVENUE_RECOGNITION_FLAG='Yes' AND isnull(DESIGN_WIN_DATE) AND

date(DESIGN_IN_DATE)>='03/29/2010' AND date(DESIGN_IN_DATE)<='04/03/2011' AND IS_PART_ACTIVE='1', DESIGN_IN_DATE-CREATED_DATE))

sum(if(FACT_TYPE='Current' AND FLAG_HEALTH_REPORT='1' AND LINE_ITEM_STATUS='Design Win' AND REVENUE_RECOGNITION_FLAG='Yes' AND

date(DESIGN_WIN_DATE)>='03/29/2010' AND date(DESIGN_WIN_DATE)<='04/03/2011'AND IS_PART_ACTIVE='1', DESIGN_WIN_DATE-CREATED_DATE))

Thanks in advance,

regards,

Bikash

topic Isnull in set analysis in QlikView

Isnull in set analysis