topic Re: Autofill column with one single field in QlikView

Autofill column with one single field

Wed, 25 Nov 2015 13:36:07 GMT

Hi all:

I receive the same table every month. The format is the same, so they autoconcatenate. The problem I have is that some of the fields are empty and I'd like to fill them with the monthly value of every table.

After my load, I have this table:

FECHA	CS_AD_CO_RANGO_INFERIOR	CS_AD_CO_INDICADOR
31/01/2015	0,75	CO
	0,5	CO
	0	CO
28/02/2015	0,75	CO
	0,5	CO
	0	CO
31/03/2015	0,75	CO
	0,5	CO
	0	CO

And I'd like to get this:

FECHA	CS_AD_CO_RANGO_INFERIOR	CS_AD_CO_INDICADOR
31/01/2015	0,75	CO
31/01/2015	0,5	CO
31/01/2015	0	CO
28/02/2015	0,75	CO
28/02/2015	0,5	CO
28/02/2015	0	CO
31/03/2015	0,75	CO
31/03/2015	0,5	CO
31/03/2015	0	CO

How could I fill the empty cells of the FECHA column with their corresponding value?

Thanks a lot for your help!!

Regards,

Vincent

Re: Autofill column with one single field

sunny_talwar — Wed, 25 Nov 2015 13:56:33 GMT

May be something like this?

If(Len(Trim(FECHA)) = 0, Previous('FECHA'), FECHA) as FECHA

Re: Autofill column with one single field

Wed, 25 Nov 2015 14:07:40 GMT

Not yet at all... it has just filled one of the two empty fields. 😞

Thanks anyway for your help Sunny! If you have another idea, I'll be happy to ear it!

Re: Autofill column with one single field

sunny_talwar — Wed, 25 Nov 2015 15:12:08 GMT

Can you try it with Peek() Instead of Previous may be

If(Len(Trim(FECHA)) = 0, Peek('FECHA'), FECHA) as FECHA

or this:

If(Len(Trim(FECHA)) = 0, Peek('FECHA1'), FECHA) as FECHA1

Re: Autofill column with one single field

tamilarasu — Wed, 25 Nov 2015 15:42:43 GMT

Hi Vincent,

You can fill empty cells by using file wizard. Use enable transformation step, there you can see fill option. Just click and enter the colum number in popup boc and select "is empty" by using cell condition button.

Re: Autofill column with one single field

Thu, 26 Nov 2015 08:29:45 GMT

I've just tried it Tamil and it works!! Thanks a lot for your help!!

Re: Autofill column with one single field

tamilarasu — Thu, 26 Nov 2015 09:53:19 GMT

You are welcome Vincent.