Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

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
Creator
Creator

Re: Replacing Null text values with a value

Try this,

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

)

Regards,
Afsar Shaikh
Project Manager- QlikView Dev. & Support
Afsar Shaikh
Email- afsar.shaikh@live.com
Highlighted
Master II
Master 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?