topic Re: How to feel the column in QlikView

How to feel the column

prma7799 — Thu, 05 Feb 2015 05:04:57 GMT

Hi All,

If I have one column in my table with some blank value and I want to feel that value with "NA".

How to do this?

Thanks

Re: How to feel the column

prma7799 — Thu, 05 Feb 2015 05:06:37 GMT

Sorry I have excel sheet.

Re: How to feel the column

Thu, 05 Feb 2015 05:08:23 GMT

Hi,

try this

load

if(len(trim(field))=0,'NA',field) as field

from excel.

Regards

$@M

Re: How to feel the column

tresB — Thu, 05 Feb 2015 05:08:33 GMT

Try like:

Load

If(Len(Trim(YourField))=0, 'NA', YourField) as YourField

From <>;

Re: How to feel the column

prma7799 — Thu, 05 Feb 2015 05:14:41 GMT

I want to do this activity using "Enable Transformation Step"

Re: How to feel the column

prma7799 — Thu, 05 Feb 2015 05:16:03 GMT

And I have multiple column like that.

Re: How to feel the column

tresB — Thu, 05 Feb 2015 05:22:28 GMT

If you are talking about Fill in the transformation step, it is actually filling with some other cell's value(from left/right/below/above); you can probably not fill with specific value.

Re: How to feel the column

prma7799 — Thu, 05 Feb 2015 05:29:39 GMT

Hi Tresesco,

then what is another option to do this.

Thanks

Re: How to feel the column

tresB — Thu, 05 Feb 2015 05:37:17 GMT

If they are really NULL, you could use NullAsValue, like:

NullAsValue *;

Set NullValue='NA';

Otherwise(if they are not nulls always but might have space or so), apart from doing similarly for all fields like showed above, you might handle them in the front end(replacing nulls or '-' with 'NA' in the chart) .

Re: How to feel the column

ashfaq_haseeb — Thu, 05 Feb 2015 06:58:42 GMT

Hi Prashant,

This might help you

NULL handling in QlikView

Regards

ASHFAQ

Re: How to feel the column

MarcoWedel — Thu, 05 Feb 2015 07:57:36 GMT

If(Len(Field),Field,'NA')