How to show the Blank value

[Karim_Khan]

Hi Team,

     In My Excel data there are 6 fields are there out of that 1 filed is blank.

When I am applying the filter and by selecting the Blank filter it showing some Data.But when I upload the Same xls File in Qlik View.Blank Field is getting skipped.How to show that.

Regards,

K K

[kaushiknsolanki · Accepted solution]

Hi,

Try this.

LOAD If(Isnull(Company) or Company='','No Data',Company) as Company,

     Cost

FROM

Blank_Value.xlsx

(ooxml, embedded labels, table is Sheet1);

Regards,

Kaushik Solanki

[alex_millan]

Hi Karim,

try to exchange the original null value for company in the excel file for a 'N/D' value in the script.

You can solve it by modifying the script a bit:

LOAD If(Len(Company)=0,'N/D',Company) As Company, Cost;

LOAD Company,

     Cost

FROM

\\india.eclerx.com\ctrxdata\ARLM_R_DATA\Karim.Khan\Desktop\Blank_Value.xlsx

(ooxml, embedded labels, table is Sheet1);

Note that to check the null values, I use the len function. I've been fooled a couple of times using comparisons like isnull(field) or field = '' and the best way I've found to deal with that is with len(field) = 0

HTH

Regards

[Karim_Khan]

Tnx

[Karim_Khan]

Tnx