topic Re: How to show the Blank value in QlikView

How to show the Blank value

Karim_Khan — Tue, 25 Aug 2015 14:13:00 GMT

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

Re: How to show the Blank value

kaushiknsolanki — Tue, 25 Aug 2015 14:19:05 GMT

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

Re: How to show the Blank value

alex_millan — Tue, 25 Aug 2015 14:19:09 GMT

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

Re: How to show the Blank value

Karim_Khan — Tue, 25 Aug 2015 14:28:03 GMT

Tnx

Re: How to show the Blank value

Karim_Khan — Tue, 25 Aug 2015 14:28:11 GMT

Tnx