Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
dmxmikey
Creator
Creator

Default values

I have created a report that i export and some of the fields are blank in database.  below is a sample of data and was wondering if its possible on my script to say  if blank or ( - ) use default?

the data is coming from multiple tables.

CodeIronchodescription
5-

test

651
444via
5 Replies
Chanty4u
MVP
MVP

if blank what do you want to see ?

YoussefBelloum
Champion
Champion

Hi,

what do you mean USE DEFAULT ?

remi_roland
Partner - Contributor III
Partner - Contributor III

Hi,

You can set a value instead of null for some columns only or every column (replace F1 by *);

It will write the value instead of null inside the data model.

NullAsValue F1;

Set NullValue = 'NULL';

LOAD null() as F1 AutoGenerate 1;

If you are using qlikview and if you want do that only in your table

You can do properties on the graph -> presentation tab you will have null symbol and missing symbol you can replace.

Regards

dmxmikey
Creator
Creator
Author

if blank return empty

Chanty4u
MVP
MVP

try this in script

if(len(trim(Field))=0, '',Field) as NewField