topic previous record existing in QlikView https://community.qlik.com/t5/QlikView/previous-record-existing/m-p/533137#M684596 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>Could you please with one calculation in a script. In attached qvw example I have two column %userid and register_data. In result, I would like to get column is_repeated which represent 0 or 1 . If current record have previous records where current register_date &gt; previous register_date records for defined userid then 1 else 0. Desired result in picture. </P><P>Thank you very much for any help.</P></BODY></HTML> Sun, 19 Jan 2014 15:57:18 GMT 2014-01-19T15:57:18Z previous record existing https://community.qlik.com/t5/QlikView/previous-record-existing/m-p/533137#M684596 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>Could you please with one calculation in a script. In attached qvw example I have two column %userid and register_data. In result, I would like to get column is_repeated which represent 0 or 1 . If current record have previous records where current register_date &gt; previous register_date records for defined userid then 1 else 0. Desired result in picture. </P><P>Thank you very much for any help.</P></BODY></HTML> Sun, 19 Jan 2014 15:57:18 GMT https://community.qlik.com/t5/QlikView/previous-record-existing/m-p/533137#M684596 2014-01-19T15:57:18Z Re: previous record existing https://community.qlik.com/t5/QlikView/previous-record-existing/m-p/533138#M684597 <HTML><HEAD></HEAD><BODY><P>If your source data already is ordered by register_date you can simply use the exists function:</P><P><BR />Load %userid, register_data,<STRONG> if(exists(%userid),1,0)</STRONG> as is_repeated</P><P>from ...</P><P></P><P>If your source data is not ordered by register_date you need to do that first and at the same time you can create the is_repeated field with the <EM>previous</EM> function.</P><P></P><P>see attached qvw.</P></BODY></HTML> Sun, 19 Jan 2014 16:08:32 GMT https://community.qlik.com/t5/QlikView/previous-record-existing/m-p/533138#M684597 Gysbert_Wassenaar 2014-01-19T16:08:32Z