How to ignore a particular value?

[psk180590]

Hello All,

I have some data which has some junk values like '-' in place of real data. I'm looking to avoid loading such values to QlikView via script.

I have tries "-=" and "<>" options but, both don't seem to work for me.

Can any one point if there are any better options.

TIA!!

[sunny_talwar]

Can you share the exact where clause you are using?

[psk180590]

Hi Sunny,

The LOAD statement is as follows:

Table1:

LOAD

Date,

FID,

Fnr,

Ftext,

Eid,

Company

Where Fnr -='-'

Order by Fnr

Resident Table;

[sdmech81 · Accepted solution]

Hi,

R u getting these '-' values after loading, then QLikview shows NULL values as '-'  .

Use in script NullAsvalue function to handle them or.

For details plss check NULL handling in QlikView

Hope it helps,if not revert with elaboration.

Sachin

[surendraj]

You should use replace function

replace(Fnr,'-','0')

it will give you zero values insted of junk values.

[psk180590]

stalwar1‌

I have also tried with Len(Fnr)>1. This also somehow doesn't help.

[sunny_talwar]

Can you share an image of the '-' in your front end of the application?

[Anonymous]

You state resident first and then the where clause.

Table1:

LOAD

Date,

FID,

Fnr,

Ftext,

Eid,

Company

Resident Table

Where Fnr -='-'

Order by Fnr

;

[psk180590]

The last column here is the Fnr field i mentioned above.

[psk180590]

I wrote the false order here, but in my application it is as you suggested.

Resident first followed by Where and Order.