NullAsValue

[#1]

Good morning,

I wrote:

ODBC CONNECT TO abc;

NullAsValue *;

Set NullValue = '0 ';

SQL SELECT ......;

But null values ​​remain, how can I do?

Thank you

[Anonymous]

Hi,

Try adding NullInterpret function above null value function, you may have blank which are not converting into 0.

SET NullInterpret ='';

NullAsValue pc;

Set NullValue = '0';

[alexandros17]

Where do you load the field PC, from a table or from an external file?

[#4]

Nothing..

I tried to see the table and the values ​​that are null QlikView tells me that in fact they are already at 0..

[antoniotiman]

Hi Miriana,

perhaps are You using MySQL DB ?

Antonio

[Anonymous]

Then in that case, you have problem in your expression. Can you add "Only" function for pc and check if it is working. Apparently it should be Sum(pc) but not sure about you dataset so cannot comment.

Sum ({$<numero={'5'}}> qty) * Only(pc)

[#7]

No, I use SQL Server..

[#8]

Nothing again..

[#9]

From a table..

[olivetwist]

I think you would need to do a preceding load. it wont replace nulls in a select in my experience.