topic Fill column with above data in QlikView

Fill column with above data

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

Hi,

I have a raw data like this:

I want to fill blank regional column with the value above.

So the record will be like this:

Is it possible to make it ?

Thanks in advance.

sumit_ranjan_pa — Fri, 24 Mar 2017 06:20:57 GMT

Hi Chou,

This is possible but solutions might depend on the data.

Can you please provide more details or your load query and sample data for this?

Is there any condition you have which is making the load on the first column possible or you want it to be random filled?

Thanks and regards,

Sumit

stonecold111 — Fri, 24 Mar 2017 07:00:58 GMT

if(regional=null(), above(regional))

use this in script

avinashelite — Fri, 24 Mar 2017 07:07:39 GMT

Try like this

IF (len(trim(Regional)) = 0, peek('Regional'), Regional) AS Regional,

Anonymous — Fri, 24 Mar 2017 09:23:33 GMT

Hi Avinash,

Thank you very much, it solved my problem perfectly.

avinashelite — Fri, 24 Mar 2017 09:42:19 GMT

Glad to help you