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]

Those seems like null or missing values to me... Is this field from another table?

Can you share the complete script?

[psk180590]

These are NULL values which QlikView converts to '-'.

I was able to solve this by writing a Where Len()<> for all the applicable fields.

[psk180590]

Hello All,

Thanks for your prompt suggestions. The issue here is these are NULL values which are converted to '-' by Qlikview.

I was able to solve it by writing a Where Len()<> 0 condition on all the applicable fields.

[sdmech81]

Hi,Check out this..

Convert Null values using NullAsValue statement in QlikView - YouTube

You can handle it in still better.

Sachin

[psk180590]

Hi Sachin,

Sure i will. Thanks!!