topic Grabbing a value without a unique flag?! in QlikView https://community.qlik.com/t5/QlikView/Grabbing-a-value-without-a-unique-flag/m-p/300683#M111319 <HTML><HEAD></HEAD><BODY><P>Hello all</P><P></P><P>How can I right an expression that will identify the first appearance of '1' and the last appearance of '1' and grab the value in the previous column??</P><P></P><P>I have attached a QVW to hopefully make it a little easier to understand.</P><P></P><P>I would like to be able to identify the '1103' and the '1202' so I can write 'Period between 1103-1202'.</P><P></P><P>Cheers guys</P><P>Robbie</P></BODY></HTML> Fri, 22 Jul 2011 13:31:46 GMT Anonymous 2011-07-22T13:31:46Z Grabbing a value without a unique flag?! https://community.qlik.com/t5/QlikView/Grabbing-a-value-without-a-unique-flag/m-p/300683#M111319 <HTML><HEAD></HEAD><BODY><P>Hello all</P><P></P><P>How can I right an expression that will identify the first appearance of '1' and the last appearance of '1' and grab the value in the previous column??</P><P></P><P>I have attached a QVW to hopefully make it a little easier to understand.</P><P></P><P>I would like to be able to identify the '1103' and the '1202' so I can write 'Period between 1103-1202'.</P><P></P><P>Cheers guys</P><P>Robbie</P></BODY></HTML> Fri, 22 Jul 2011 13:31:46 GMT https://community.qlik.com/t5/QlikView/Grabbing-a-value-without-a-unique-flag/m-p/300683#M111319 Anonymous 2011-07-22T13:31:46Z Re: Grabbing a value without a unique flag?! https://community.qlik.com/t5/QlikView/Grabbing-a-value-without-a-unique-flag/m-p/300684#M111320 <HTML><HEAD></HEAD><BODY><P>Hi Robbie</P><P></P><P>Use:</P><P></P><P><SPAN style="font-family: 'Arial','sans-serif'; color: black; font-size: 9pt;">='Period between ' &amp; </SPAN><SPAN style="font-family: 'Arial','sans-serif'; color: blue; font-size: 9pt;">Min</SPAN><SPAN style="font-family: 'Arial','sans-serif'; color: black; font-size: 9pt;">({&lt;</SPAN><SPAN style="font-family: 'Arial','sans-serif'; color: maroon; font-size: 9pt;">RollingPeriodFlag</SPAN><SPAN style="font-family: 'Arial','sans-serif'; color: black; font-size: 9pt;">={'1'}&gt;} </SPAN><SPAN style="font-family: 'Arial','sans-serif'; color: maroon; font-size: 9pt;">Period</SPAN><SPAN style="font-family: 'Arial','sans-serif'; color: black; font-size: 9pt;">) &amp; ' and ' &amp; </SPAN><SPAN style="font-family: 'Arial','sans-serif'; color: blue; font-size: 9pt;">Max</SPAN><SPAN style="font-family: 'Arial','sans-serif'; color: black; font-size: 9pt;">({&lt;</SPAN><SPAN style="font-family: 'Arial','sans-serif'; color: maroon; font-size: 9pt;">RollingPeriodFlag</SPAN><SPAN style="font-family: 'Arial','sans-serif'; color: black; font-size: 9pt;">={'1'}&gt;} </SPAN><SPAN style="font-family: 'Arial','sans-serif'; color: maroon; font-size: 9pt;">Period</SPAN><SPAN style="font-family: 'Arial','sans-serif'; color: black; font-size: 9pt;">)&nbsp; </SPAN></P><P></P><P><SPAN style="font-family: 'Arial','sans-serif'; color: black; font-size: 9pt;">All the best</SPAN></P><P><SPAN style="font-family: 'Arial','sans-serif'; color: black; font-size: 9pt;"> </SPAN></P><P><SPAN style="font-family: 'Arial','sans-serif'; color: black; font-size: 9pt;">Derek</SPAN></P></BODY></HTML> Fri, 22 Jul 2011 13:42:22 GMT https://community.qlik.com/t5/QlikView/Grabbing-a-value-without-a-unique-flag/m-p/300684#M111320 derekjones 2011-07-22T13:42:22Z Grabbing a value without a unique flag?! https://community.qlik.com/t5/QlikView/Grabbing-a-value-without-a-unique-flag/m-p/300685#M111321 <HTML><HEAD></HEAD><BODY><P>Cheers Derek</P><P></P><P>I need to get my head around Set Analysis!!!!</P><P></P><P></P><P>Thanks</P><P>Robbie</P></BODY></HTML> Fri, 22 Jul 2011 14:03:19 GMT https://community.qlik.com/t5/QlikView/Grabbing-a-value-without-a-unique-flag/m-p/300685#M111321 Anonymous 2011-07-22T14:03:19Z