topic Re: autofill empty field in QlikView

autofill empty field

Wed, 01 Aug 2012 13:19:36 GMT

Hi all,

i got a problem.

I got a filed with 3 values:

- A

- B

- empty

I need to replace the empty fields with "C", i'm trying to build a new field using if functions without success, any suggestion?

Thanks

Re: autofill empty field

MayilVahanan — Wed, 01 Aug 2012 13:22:45 GMT

Try like this,

Load *, if(Len(Trim(Field)) > 0, FieldName, 'C') as fieldname from tablename;

Hope it helps

Re: autofill empty field

Wed, 01 Aug 2012 13:26:10 GMT

but in the new field i should also keep A and B

Re: autofill empty field

MayilVahanan — Wed, 01 Aug 2012 13:29:58 GMT

Len(Trim(FieldName)) gives the length of the field value, if is less than 1 means, it replace the empty string with 'C' otherwise it keeps the original value. so, A and B also there .

If(Len(Trim(FieldName)) >0 , FieldName, 'C') gives A,B and C

Hope it helps

Re: autofill empty field

Wed, 01 Aug 2012 13:49:52 GMT

is not working...maybe the syntax is incorrect

Re: autofill empty field

CELAMBARASAN — Wed, 01 Aug 2012 13:54:12 GMT

Can you post the syntax you used?

Re: autofill empty field

MayilVahanan — Wed, 01 Aug 2012 13:56:23 GMT

Check the attached file..

Re: autofill empty field

Thu, 02 Aug 2012 09:18:02 GMT

if(Len(Trim([Tipo ])) > 0, [Tipo],'C') as "AA"

In the new columns it gives me the correct field (a & b), but still left empty the empty ones

Re: autofill empty field

Thu, 02 Aug 2012 09:27:08 GMT

I also tried with

if([Tipo]='A','A', if([Tipo]='B','B','C')) as "AAA"

and

If (IsNull([Tipo]),'C', [Tipo]) as "BBB"

but is still have no C

It seems like the fields are not empty, consider that they are populated as calculation of other fields

Re: autofill empty field

Thu, 02 Aug 2012 10:10:24 GMT

This is a formatting problem

You need to format you inline as txt

Load

*
,if(Len(Trim(Testing))<>0, Testing, 'C') as Test Inline
[
Testing,Value
A,1
B,2
,3
D,4
](TXT);