topic Number Fields in QlikView https://community.qlik.com/t5/QlikView/Number-Fields/m-p/415691#M154594 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>How do I number the inspections for each PMP_CODE so, as an example, I can then retrieve the last two inspections done on each property (denoted by PMP_CODE)?</P><P></P><P><IMG __jive_id="35938" class="jive-image-thumbnail jive-image" onclick="" alt="Property &amp; Inspections.PNG" src="/legacyfs/online/35938_Property &amp; Inspections.PNG" width="450" /></P><P></P><P>Outcome would be:</P><P><IMG __jive_id="35943" class="jive-image-thumbnail jive-image" onclick="" alt="Property &amp; Inspections2.PNG" src="/legacyfs/online/35943_Property &amp; Inspections2.PNG" width="450" /></P></BODY></HTML> Wed, 03 Apr 2013 03:19:07 GMT 2013-04-03T03:19:07Z Number Fields https://community.qlik.com/t5/QlikView/Number-Fields/m-p/415691#M154594 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>How do I number the inspections for each PMP_CODE so, as an example, I can then retrieve the last two inspections done on each property (denoted by PMP_CODE)?</P><P></P><P><IMG __jive_id="35938" class="jive-image-thumbnail jive-image" onclick="" alt="Property &amp; Inspections.PNG" src="/legacyfs/online/35938_Property &amp; Inspections.PNG" width="450" /></P><P></P><P>Outcome would be:</P><P><IMG __jive_id="35943" class="jive-image-thumbnail jive-image" onclick="" alt="Property &amp; Inspections2.PNG" src="/legacyfs/online/35943_Property &amp; Inspections2.PNG" width="450" /></P></BODY></HTML> Wed, 03 Apr 2013 03:19:07 GMT https://community.qlik.com/t5/QlikView/Number-Fields/m-p/415691#M154594 2013-04-03T03:19:07Z Re: Number Fields https://community.qlik.com/t5/QlikView/Number-Fields/m-p/415692#M154595 <HTML><HEAD></HEAD><BODY><P>hi kieran,</P><P></P><P>in expression give, 1 and select full accumulation.</P><P></P><P>kindly check the attachment file.</P><P></P><P></P><P>Muni</P></BODY></HTML> Wed, 03 Apr 2013 05:44:57 GMT https://community.qlik.com/t5/QlikView/Number-Fields/m-p/415692#M154595 muniyandi 2013-04-03T05:44:57Z