Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jayati_shrivast
New Contributor II

Fill column null value with previous not null value

Hi All,

I have a straight table layout as follows

ID             MODE       MSG

11                a                "how may i help u"

11                b                  null

12                a                 "may i know your name"

12                b                    null

13                 a                 "pls provide your contact details"

13                 b                    null

 

In place of null, I need to paste the same msg corresponding to particular ID  where mode = a  that is I should get the display as follows:

ID             MODE       MSG

11                a                "how may i help u"

11                b                 "how may i help u"

12                a                 "may i know your name"

12                b                  "may i know your name"

13                 a                 "pls provide your contact details"

13                 b                  "pls provide your contact details"

 

how can i implement this, pls help me out. In the database from where I am retrieving the data, for mode = b for all the id's msg  value is null. I need to implement the above in qliksense

Thanks