Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Code | Iron | cho | description |
---|---|---|---|
5 | - | test | |
6 | 5 | 1 | |
4 | 4 | 4 | via |
if blank what do you want to see ?
Hi,
what do you mean USE DEFAULT ?
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
if blank return empty
try this in script
if(len(trim(Field))=0, '',Field) as NewField