topic Re: creating flag if value is minimum in QlikView https://community.qlik.com/t5/QlikView/creating-flag-if-value-is-minimum/m-p/366264#M494695 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>See the attached qvw/</P><P></P><P>Hope it help.</P></BODY></HTML> Fri, 23 Mar 2012 09:45:03 GMT 2012-03-23T09:45:03Z creating flag if value is minimum https://community.qlik.com/t5/QlikView/creating-flag-if-value-is-minimum/m-p/366263#M494694 <HTML><HEAD></HEAD><BODY><P>hi everybody,</P><P></P><P>I have following table: </P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="184" style="border: 1px solid #000000; width: 710px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>OrderId<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>OrderDate</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SessionDate<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>OrderSessionDate-Diff</STRONG></SPAN><BR /></TH></TR><TR><TD>AA</TD><TD>2011-07-15 12:07:00</TD><TD>2011-07-15 12:00:00</TD><TD>00:07</TD></TR><TR><TD>BB</TD><TD>2011-11-06 21:12:00</TD><TD>2011-11-06 21:00:00</TD><TD>00:12</TD></TR><TR><TD>BB</TD><TD>2011-11-06 21:12:00</TD><TD>2011-11-06 21:06:00</TD><TD>00:06</TD></TR><TR><TD>BB</TD><TD>2011-11-06 21:12:00</TD><TD>2011-11-06 21:20:00</TD><TD>-00:08</TD></TR><TR><TD>CC</TD><TD>2011-03-18 23:04:00</TD><TD>2011-03-18 23:00:00</TD><TD>00:04</TD></TR><TR><TD>CC</TD><TD>2011-03-18 23:04:00</TD><TD>2011-03-18 23:10:00</TD><TD>-00:06</TD></TR><TR><TD>DD</TD><TD>2011-02-08 14:08:00</TD><TD>2011-02-08 14:07:00</TD><TD>00:01</TD></TR></TBODY></TABLE><P></P><P>I need a table with a flag column that identified the row with minimum value of column 'OrderSessionDate-Diff' for each order.</P><P>My result should look like this:</P><P></P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="186" style="border: 1px solid #000000; width: 779px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>OrderId</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>OrderDate</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SessionDate</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>OrderSessionDate-Diff</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Flag</STRONG></SPAN></TH></TR><TR><TD>AA</TD><TD>2011-07-15 12:07:00</TD><TD>2011-07-15 12:00:00</TD><TD>00:07</TD><TD>Yes</TD></TR><TR><TD>BB</TD><TD>2011-11-06 21:12:00</TD><TD>2011-11-06 21:00:00</TD><TD>00:12</TD><TD>No</TD></TR><TR><TD>BB</TD><TD>2011-11-06 21:12:00</TD><TD>2011-11-06 21:06:00</TD><TD>00:06</TD><TD>Yes</TD></TR><TR><TD>BB</TD><TD>2011-11-06 21:12:00</TD><TD>2011-11-06 21:20:00</TD><TD>-00:08</TD><TD>No</TD></TR><TR><TD>CC</TD><TD>2011-03-18 23:04:00</TD><TD>2011-03-18 23:00:00</TD><TD>00:04</TD><TD>Yes</TD></TR><TR><TD>CC</TD><TD>2011-03-18 23:04:00</TD><TD>2011-03-18 23:10:00</TD><TD>-00:06</TD><TD>No</TD></TR><TR><TD>DD</TD><TD>2011-02-08 14:08:00</TD><TD>2011-02-08 14:07:00</TD><TD>00:01</TD><TD>Yes</TD></TR></TBODY></TABLE><P></P><P>Please help, THX!</P></BODY></HTML> Fri, 23 Mar 2012 09:39:42 GMT https://community.qlik.com/t5/QlikView/creating-flag-if-value-is-minimum/m-p/366263#M494694 2012-03-23T09:39:42Z Re: creating flag if value is minimum https://community.qlik.com/t5/QlikView/creating-flag-if-value-is-minimum/m-p/366264#M494695 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>See the attached qvw/</P><P></P><P>Hope it help.</P></BODY></HTML> Fri, 23 Mar 2012 09:45:03 GMT https://community.qlik.com/t5/QlikView/creating-flag-if-value-is-minimum/m-p/366264#M494695 2012-03-23T09:45:03Z