Logic to use previous row issue

[alec1982]

hi,

I have the following table

ColumnA     ColumnB     ColumnC     Question     SubQ         Answer

John              10.1.1.1     1/1/2016     Hello                               Hi

John              10.1.1.1     1/1/2016     Where        

John              10.1.1.1     1/1/2016                         is Home     Atlanta

John              10.1.1.1     1/1/2016                         is Work      Downtown

John              10.1.1.1     1/1/2016                         is School    Kennesaw

as you noticed on Question column.. sometime it might have sub questions and they are listed on the next rows and also the subQ is used.. 

I need to change the structure a little bit on the script side as follow

ColumnA     ColumnB     ColumnC     Question     SubQ       Answer

John              10.1.1.1     1/1/2016     Hello                            Good

John              10.1.1.1     1/1/2016     Where        is Home     Atlanta

John              10.1.1.1     1/1/2016     Where        is Work      Downtown

John              10.1.1.1     1/1/2016     Where        is School    Kennesaw

[albertovarela]

take a look at this post Generating Missing Data In QlikView

[aarkay29]

Something like this would work

If(ColumnA=peek(ColumnA),

     If(ISNULL(Question),

          If(ISNULL(peek(Question)),peek(NEWFIELD),peek(Question)),Question),Question) as NEWFIELD

[Anonymous]

Hi Harfoush,

Check the attached APP