topic Re: Default values in QlikView

Default values

dmxmikey — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Default values

Chanty4u — Wed, 28 Feb 2018 13:20:07 GMT

if blank what do you want to see ?

Re: Default values

YoussefBelloum — Wed, 28 Feb 2018 13:21:44 GMT

Hi,

what do you mean USE DEFAULT ?

Re: Default values

remi_roland — Wed, 28 Feb 2018 13:29:13 GMT

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

Re: Default values

dmxmikey — Wed, 28 Feb 2018 13:30:51 GMT

if blank return empty

Re: Default values

Chanty4u — Wed, 28 Feb 2018 13:35:35 GMT

try this in script

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