topic Re: Replacing Null text values with a value in QlikView

Replacing Null text values with a value

Mon, 20 May 2013 15:33:43 GMT

Hi -

I am trying to replace blank text field values using the following expression.

=if(WildMatch([Text],'*NULL*'),'Testing',[Text])

For some reason this formula does not work and blank rows were not replaces with 'Texting'.

Please help.

Thank you!

Re: Replacing Null text values with a value

alexandros17 — Mon, 20 May 2013 15:48:59 GMT

try this

if(isnull(text), 'Testing', text)

Re: Replacing Null text values with a value

Mon, 20 May 2013 16:09:24 GMT

It doesnt work. Any other options?

Re: Replacing Null text values with a value

arbernardez_old — Fri, 22 Nov 2013 11:51:54 GMT

if(len(trim(text))=0, 'Testing', text)

Re: Replacing Null text values with a value

stevedark — Fri, 22 Nov 2013 12:01:50 GMT

HI Zhenya,

It may be that these are not null values on a row (where the if(isnull syntax would work) rather places where there are no values due to associations between tables not joining up?

In these cases you can't easily populate values, but there are usually ways around it.

Can you please give a bit more detail about your data model and where you want the Nulls replaced?

Steve

Re: Replacing Null text values with a value

Fri, 22 Nov 2013 12:02:18 GMT

hi,

try this,

if(IsNull(Text) or Text= '', 'Testing', Text)

Regards,

Ashutosh

Re: Replacing Null text values with a value

sujeetsingh — Fri, 22 Nov 2013 12:06:11 GMT

Steve you are right man it is the data model issue and hence need to handle in script.

Re: Replacing Null text values with a value

Anonymous — Wed, 13 Sep 2017 20:59:25 GMT

Hi Sujeet,

Can you explain how to handle this scenario in script?

Thanks,

Sandeep

Re: Replacing Null text values with a value

Anil_Babu_Samineni — Thu, 14 Sep 2017 02:50:08 GMT

One option could be this?

Set Nullinterpret = 'NULL';

NullasValue *; // You can define the fields

Set NullValue = 'Testing';

Re: Replacing Null text values with a value

vardhancse — Thu, 14 Sep 2017 04:47:25 GMT

Hi,

Can try this:

In chart Expression:

=IF(Len(Trim(Dim))=0,'N/A',Dim)

Even in script also we can use

Re: Replacing Null text values with a value

vardhancse — Thu, 14 Sep 2017 05:19:12 GMT

Hi,

Can try this:

In chart Expression:

=IF(Len(Trim(Dim))=0,'N/A',Dim)

Even in script also we can use

Re: Replacing Null text values with a value

afsarshaikh — Thu, 14 Sep 2017 06:15:38 GMT

Try this,

=if( len([Text] < 0, 'Testing', [Text])

)

Re: Replacing Null text values with a value

prieper — Thu, 14 Sep 2017 07:31:40 GMT

Might be worth to challenge your datamodel.

Are you supposed to have missing entries, or can you fix somehow in the script by reducing linked fields (e.g. using LEFT JOIN or LEFT KEEP).

Can you post an example in order to validate, whether it comes from data or from the datamodel?