topic Re: Fill in the blank data columns in QlikView

Fill in the blank data columns

Anonymous — Tue, 12 Jan 2016 00:14:06 GMT

Can someone give me some help working through this issue. I need to fill blank columns with data from previous row. I tried several approach but no luck. Any insight is appreciated.

Original Table:

Desired Table

Re: Fill in the blank data columns

manojkulkarni — Tue, 12 Jan 2016 07:59:39 GMT

This you can do while loading data. With Load Wizard , Select Enable Transformation & then use Fill option to do this operation.

Re: Fill in the blank data columns

tresB — Tue, 12 Jan 2016 08:04:18 GMT

try like:

Load
      If(Len(trim(Dim1))>0, Dim1, Peek(Dim1)) as Dim1,
      Dim2,

      Amt;

Load * Inline [
Dim1, Dim2, Amt
AA, bbb, 100
, ccc, 200
, ddd, 300
BB, xxx, 400
, yyy, 500
, zzz, 600 ]

Re: Fill in the blank data columns

NareshGuntur — Tue, 12 Jan 2016 08:49:43 GMT

This might help you

Peek till not null

Cheers,

Naresh

Re: Fill in the blank data columns

Anonymous — Tue, 12 Jan 2016 11:41:39 GMT

Thanks for the reply. This works Great

Re: Fill in the blank data columns

tresB — Tue, 12 Jan 2016 12:16:09 GMT

Try to mark the 'Correct Answer' the one reply which is so. That will help many(including me) in many ways.