topic selection of string value in expression for field value in QlikView https://community.qlik.com/t5/QlikView/selection-of-string-value-in-expression-for-field-value/m-p/798506#M281971 <HTML><HEAD></HEAD><BODY><P>Dear Experts,</P><P></P><P>Help required to evaluate the following expression so that it will eliminate MaxID=41483 from selection and get only 'Max' field value in column. </P><P></P><P>Using following formula</P><P></P><P>Activity Count=Count({&lt; MaxID = {"='&gt;=' &amp; 'Max' &amp; '&lt;=' &amp; 'Max'"}&gt;}{&lt;Doc_Date = {"&gt;=$(vStartDate)&lt;=$(vEndDate)"}&gt;} EQUNR_S)</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 570px;"><TBODY><TR><TD class="xl63" height="17" width="161"> Activity Status</TD><TD class="xl63" style="border-left: none;" width="98">EQUNR_S</TD><TD class="xl63" style="border-left: none;" width="98">MaxID</TD><TD class="xl63" style="border-left: none;" width="98">Doc_Date</TD><TD class="xl63" style="border-left: none;" width="115">Activity Count</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Surplus</TD><TD class="xl65" style="border-top: none; border-left: none;">20432</TD><TD class="xl65" style="border-top: none; border-left: none;">41483</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">07.08.2014</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Under decommissioning</TD><TD class="xl65" style="border-top: none; border-left: none;">20432</TD><TD class="xl65" style="border-top: none; border-left: none;">Max</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">17.08.2014</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks</P><P></P><P>Ashif</P></BODY></HTML> Mon, 10 Nov 2014 09:17:31 GMT 2014-11-10T09:17:31Z selection of string value in expression for field value https://community.qlik.com/t5/QlikView/selection-of-string-value-in-expression-for-field-value/m-p/798506#M281971 <HTML><HEAD></HEAD><BODY><P>Dear Experts,</P><P></P><P>Help required to evaluate the following expression so that it will eliminate MaxID=41483 from selection and get only 'Max' field value in column. </P><P></P><P>Using following formula</P><P></P><P>Activity Count=Count({&lt; MaxID = {"='&gt;=' &amp; 'Max' &amp; '&lt;=' &amp; 'Max'"}&gt;}{&lt;Doc_Date = {"&gt;=$(vStartDate)&lt;=$(vEndDate)"}&gt;} EQUNR_S)</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 570px;"><TBODY><TR><TD class="xl63" height="17" width="161"> Activity Status</TD><TD class="xl63" style="border-left: none;" width="98">EQUNR_S</TD><TD class="xl63" style="border-left: none;" width="98">MaxID</TD><TD class="xl63" style="border-left: none;" width="98">Doc_Date</TD><TD class="xl63" style="border-left: none;" width="115">Activity Count</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Surplus</TD><TD class="xl65" style="border-top: none; border-left: none;">20432</TD><TD class="xl65" style="border-top: none; border-left: none;">41483</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">07.08.2014</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Under decommissioning</TD><TD class="xl65" style="border-top: none; border-left: none;">20432</TD><TD class="xl65" style="border-top: none; border-left: none;">Max</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">17.08.2014</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks</P><P></P><P>Ashif</P></BODY></HTML> Mon, 10 Nov 2014 09:17:31 GMT https://community.qlik.com/t5/QlikView/selection-of-string-value-in-expression-for-field-value/m-p/798506#M281971 2014-11-10T09:17:31Z