topic Re: empty cells in QlikView

empty cells

mambi — Thu, 16 Jan 2014 11:59:13 GMT

hi everyone,

i have a table with many columns containing empty cells (with null value) as in the example below :

categories	field1
category 1	sport
category 2	music
category 3	travel
category 4
category 5	games
category 6
category 7	books

for the column field1 i want to keep the blank cells after the loading script

i can get the result by using : if(isnull(fields),'',fields) as col in the load script but i have many columns so i don't want to the this test for over 10 fields , is there any way do this automatically (like verbatim for spaces)

thanks

Re: empty cells

whiteline — Thu, 16 Jan 2014 12:18:13 GMT

Hi.

In script you can use NullAsValue field1, field2, ...;

Re: empty cells

sujeetsingh — Thu, 16 Jan 2014 12:21:16 GMT

See this sample please

Re: empty cells

kiranmanoharrode — Thu, 16 Jan 2014 12:21:35 GMT

Dear Mambi,

try below script;

NullAsValue *;

Test:

Load *Inline [

categories	field1
category 1	sport
category 2	music
category 3	travel
category 4	' '
category 5	games
category 6	' '
category 7	books

];

Regards

Kiran Rode

+918976977897

Re: empty cells

Thu, 16 Jan 2014 12:22:34 GMT

if(field1=' ',' ',field1)

Re: empty cells

Anonymous — Thu, 16 Jan 2014 12:29:57 GMT

Hi Mambi,

please use the LEN Function in place of ISNULL.

like:

if(LEN(Fields),Fields,' ') AS COL

it will be work.

Thanks

SHAIK

Re: empty cells

Thu, 16 Jan 2014 12:35:28 GMT

try this

if(len(field1)=0,' ',field1)

Regards

Re: empty cells

mambi — Thu, 16 Jan 2014 12:46:31 GMT

thanks sir,

it's worked for me.