topic Re: How to replace null values in the flat file while transforming in QV? in QlikView

How to replace null values in the flat file while transforming in QV?

Tue, 09 Aug 2016 13:44:35 GMT

Recently I have received an excel file as source data, which is having lot of null values in a dimension or two. When I tryied to do transforming in the Qlikview, I could find only normal captions like fill cells Above, Below, Left, Right, but I want to replace all the null values to particular value (manual entry). Please some one help me in sorting this out.

Re: How to replace null values in the flat file while transforming in QV?

vishsaggi — Tue, 09 Aug 2016 15:47:17 GMT

Try this :

NULLASVALUE (Here:Your DimensionName thas HasNulls);

SET NullValue = '<Unknown>' ;

Then your Load script.

Re: How to replace null values in the flat file while transforming in QV?

Tue, 09 Aug 2016 17:51:01 GMT

Hi Vish,

This is very helpful.

Just eager to know Is there any other option in the QV itself (like Fill changes option) to do this changes rather than do it in the script.

Re: How to replace null values in the flat file while transforming in QV?

vishsaggi — Tue, 09 Aug 2016 19:01:20 GMT

I am not pretty sure if we can handle that in Table file transformation wizard. Once you get the data into Qlikview we can transform accordingly with local Qlikview functionality. What exactly you are looking for ?