topic Need to Capture Null value in List Box in QlikView

Need to Capture Null value in List Box

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am having blank values in "Arrival Place" field, But when i import the same file into Qlikview, It is not showing "Empty row". Which means I need to figure out the Data where the "Arrival Place = Empty". I have attached screen shot and also Excel file for reference. Thank in advance.

Re: Need to Capture Null value in List Box

sunny_talwar — Thu, 16 Jun 2016 12:58:22 GMT

Try this script:

NULLASVALUE *;

SET NullValue = ' ';

Table:

LOAD Name,

Department,

[Arrival Place],

[Departure Place],

[Arrival Time],

[Departure Time],

[Total Journey Hours],

Amount,

[Booking Date]

FROM

Example1.xlsx

(ooxml, embedded labels, table is Sheet1);

Re: Need to Capture Null value in List Box

Anonymous — Thu, 16 Jun 2016 13:13:10 GMT

Awesome, Thanks for your quick reply Sunny. Working Perfect.....