Formaulae

deepakqlikview_123 — Fri, 20 Jun 2014 04:48:24 GMT

Hi all,

Can u please suggest what below expression will return,

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

2NullAsValue Field1,Field2;

thanks

Re: Formaulae

Anonymous — Fri, 20 Jun 2014 04:53:11 GMT

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 — Fri, 20 Jun 2014 10:22:30 GMT

Thanks Nisha,

This info in helpful for me