Formaulae

[deepakqlikview_123]

Hi all,

Can u please suggest what below expression will return,

1if(isnull(SalesValue),'NULL',SalesValue)as SalesValue;

2NullAsValue Field1,Field2;

thanks

[Anonymous · Accepted solution]

Hi,

1.  if(isnull(SalesValue),'NULL',SalesValue)as SalesValue;

Isnull function will check whether the salesValue field has null or not.

If salesValue field has any null value, then it will return first condition 'NULL' , else it will take salesValue field values.

2. NullAsValue Field1,Field2;

   set NullValue='NULL';

By default Qlikview Considers Null values to be missing or undefined entities.

if field1 and field2 does not have any values, at the time it will consider that value as 'NULL'.

Ex:

SET NullInterpret ='';

NullAsValue Sales;

Set NullValue = 'NULL';

Tab:

LOAD * INLINE [

    Country, Sales

    AAA, 100

    BBB, 98

    CCCC,

    DDD, 0

    EEE

    FFF, 0

];

SET NullInterpret ='';

It will return null values for blank values in excel.

Here i have attached sample for your 2nd Question. Pls check this.

Hope it may help.

[deepakqlikview_123]

Thanks Nisha,

This info in helpful for me