Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
vardhancse
Valued Contributor II

Re: Replacing Null text values with a value

Hi,

Can try this:

In chart Expression:

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

Even in script also we can use

Highlighted
afsarshaikh
New Contributor III

Re: Replacing Null text values with a value

Try this,

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

)

Regards,
Project Manager- QlikView Dev. & Support
Afsar Shaikh
Email- afsar.shaikh@live.com
prieper
Honored Contributor II

Re: Replacing Null text values with a value

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?

Community Browser