topic Multinested previous()? in QlikView https://community.qlik.com/t5/QlikView/Multinested-previous/m-p/442850#M699782 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I've got a dataset with 2 columns where some records miss value in the first column. In these very records where values are missed I want to assign last value in the first column as shown below. I guess prevoius() will not work here. Do you have an idea how to solve it?</P><P></P><P>Regards,</P><P>Przemek</P><P></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_1353153079460617" jivemacro_uid="_1353153079460617"><P>INPUT</P><P>---------</P><P>Name, City </P><P>John, Berlin</P><P>Mary, London</P><P>, Paris</P><P>, Amsterdam</P><P></P><P>OUTPUT</P><P>-------------</P><P>Name, City</P><P>John, Berlin</P><P>Mary, London</P><P>Mary, Paris</P><P>Mary, Amsterdam</P><P></P></PRE></BODY></HTML> Sat, 17 Nov 2012 12:06:38 GMT 2012-11-17T12:06:38Z Multinested previous()? https://community.qlik.com/t5/QlikView/Multinested-previous/m-p/442850#M699782 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I've got a dataset with 2 columns where some records miss value in the first column. In these very records where values are missed I want to assign last value in the first column as shown below. I guess prevoius() will not work here. Do you have an idea how to solve it?</P><P></P><P>Regards,</P><P>Przemek</P><P></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_1353153079460617" jivemacro_uid="_1353153079460617"><P>INPUT</P><P>---------</P><P>Name, City </P><P>John, Berlin</P><P>Mary, London</P><P>, Paris</P><P>, Amsterdam</P><P></P><P>OUTPUT</P><P>-------------</P><P>Name, City</P><P>John, Berlin</P><P>Mary, London</P><P>Mary, Paris</P><P>Mary, Amsterdam</P><P></P></PRE></BODY></HTML> Sat, 17 Nov 2012 12:06:38 GMT https://community.qlik.com/t5/QlikView/Multinested-previous/m-p/442850#M699782 2012-11-17T12:06:38Z Re: Multinested previous()? https://community.qlik.com/t5/QlikView/Multinested-previous/m-p/442851#M699783 <HTML><HEAD></HEAD><BODY><P>Yup.</P><P></P><P>If(Len(Trim(Name))=0,Peek(Name),Name) as Name</P><P></P><P>HIC</P></BODY></HTML> Sat, 17 Nov 2012 12:59:51 GMT https://community.qlik.com/t5/QlikView/Multinested-previous/m-p/442851#M699783 hic 2012-11-17T12:59:51Z Re: Multinested previous()? https://community.qlik.com/t5/QlikView/Multinested-previous/m-p/442852#M699784 <HTML><HEAD></HEAD><BODY><P>Thank you, Henric.</P></BODY></HTML> Sat, 17 Nov 2012 13:29:01 GMT https://community.qlik.com/t5/QlikView/Multinested-previous/m-p/442852#M699784 2012-11-17T13:29:01Z