topic first value to be select in QlikView https://community.qlik.com/t5/QlikView/first-value-to-be-select/m-p/576617#M681971 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 512px;"><TBODY><TR><TD class="xl63" height="20" width="64">SERVICE_ID_Key</TD><TD class="xl63" width="64">TrailMAX_Cramer</TD><TD class="xl63" width="64">TrailMIN_Cramer</TD><TD class="xl63" width="64">TRAILBW</TD><TD class="xl63" width="64">TRAILCOUNT</TD><TD class="xl63" width="64">Circuit_Speed_combined</TD><TD class="xl63" width="64">SERVICETYPENAME</TD><TD class="xl63" width="64">PROVISIONSTATUSNAME</TD></TR><TR><TD height="20">091MUMB1143006126586</TD><TD align="right">155</TD><TD align="right">146</TD><TD>VC3</TD><TD align="right">4</TD><TD align="right">150</TD><TD>NDE</TD><TD>Ready - In-Service</TD></TR><TR><TD height="20">091MUMB1143006126586</TD><TD align="right">190</TD><TD align="right">150</TD><TD>VC3</TD><TD align="right">4</TD><TD align="right">150</TD><TD>NDE</TD><TD>Ready - In-Service</TD></TR></TBODY></TABLE><P>i'm jus giving one ex over here .when i'm having circuit_speed_combined field falls between two bucketsi.e. trailmin_cramer and trail_max_cramer i want first bucket shud be selected.&nbsp; but i want it in expression in front end.please help </P></BODY></HTML> Sat, 29 Mar 2014 22:48:20 GMT 2014-03-29T22:48:20Z first value to be select https://community.qlik.com/t5/QlikView/first-value-to-be-select/m-p/576617#M681971 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 512px;"><TBODY><TR><TD class="xl63" height="20" width="64">SERVICE_ID_Key</TD><TD class="xl63" width="64">TrailMAX_Cramer</TD><TD class="xl63" width="64">TrailMIN_Cramer</TD><TD class="xl63" width="64">TRAILBW</TD><TD class="xl63" width="64">TRAILCOUNT</TD><TD class="xl63" width="64">Circuit_Speed_combined</TD><TD class="xl63" width="64">SERVICETYPENAME</TD><TD class="xl63" width="64">PROVISIONSTATUSNAME</TD></TR><TR><TD height="20">091MUMB1143006126586</TD><TD align="right">155</TD><TD align="right">146</TD><TD>VC3</TD><TD align="right">4</TD><TD align="right">150</TD><TD>NDE</TD><TD>Ready - In-Service</TD></TR><TR><TD height="20">091MUMB1143006126586</TD><TD align="right">190</TD><TD align="right">150</TD><TD>VC3</TD><TD align="right">4</TD><TD align="right">150</TD><TD>NDE</TD><TD>Ready - In-Service</TD></TR></TBODY></TABLE><P>i'm jus giving one ex over here .when i'm having circuit_speed_combined field falls between two bucketsi.e. trailmin_cramer and trail_max_cramer i want first bucket shud be selected.&nbsp; but i want it in expression in front end.please help </P></BODY></HTML> Sat, 29 Mar 2014 22:48:20 GMT https://community.qlik.com/t5/QlikView/first-value-to-be-select/m-p/576617#M681971 2014-03-29T22:48:20Z