topic Re: How to always show a value in QlikView https://community.qlik.com/t5/QlikView/How-to-always-show-a-value/m-p/945432#M955386 <HTML><HEAD></HEAD><BODY><P>What if you use the expression <STRONG>Min(</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>DaysSinceLastIncident)</STRONG></SPAN></P></BODY></HTML> Thu, 19 Nov 2015 20:11:02 GMT sunny_talwar 2015-11-19T20:11:02Z How to always show a value https://community.qlik.com/t5/QlikView/How-to-always-show-a-value/m-p/945429#M955383 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a chart that displays Days since last Incident and everything is good but when I select multiple segments I do not get a result.&nbsp; I would want to see the smallest value when more than one segment is selected.&nbsp; </P><P></P><P>Any help would be much appreciated.</P><P></P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>DaysSinceLastIncident</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>MaxIncidentDate</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Segment</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">322</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">42005</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">AWP</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">353</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">41974</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">CON</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">353</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">41974</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">CORP</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">353</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">41974</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">CRA</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">353</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">41974</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MHPS</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">353</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">41974</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MP</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 19 Nov 2015 19:34:32 GMT https://community.qlik.com/t5/QlikView/How-to-always-show-a-value/m-p/945429#M955383 2015-11-19T19:34:32Z Re: How to always show a value https://community.qlik.com/t5/QlikView/How-to-always-show-a-value/m-p/945430#M955384 <HTML><HEAD></HEAD><BODY><P>Hi Jason,</P><P>please give us a little more details about your needs so we can help you.</P><P>Examples could be useful to better understand the results you are looking for when you select multiple segments </P><P>Regards</P><P>Andrea</P></BODY></HTML> Thu, 19 Nov 2015 19:57:32 GMT https://community.qlik.com/t5/QlikView/How-to-always-show-a-value/m-p/945430#M955384 anlonghi2 2015-11-19T19:57:32Z Re: How to always show a value https://community.qlik.com/t5/QlikView/How-to-always-show-a-value/m-p/945431#M955385 <HTML><HEAD></HEAD><BODY><P>I have a chart that displays the number in the column "DaysSinceLastIncident".&nbsp; If someone selects AWP they get 322, if they select MP they get 353, if they select AWP and MP they get no data.&nbsp; I would like it so that if they select multiple segments they receive the smaller value from the chart.</P></BODY></HTML> Thu, 19 Nov 2015 20:01:54 GMT https://community.qlik.com/t5/QlikView/How-to-always-show-a-value/m-p/945431#M955385 2015-11-19T20:01:54Z Re: How to always show a value https://community.qlik.com/t5/QlikView/How-to-always-show-a-value/m-p/945432#M955386 <HTML><HEAD></HEAD><BODY><P>What if you use the expression <STRONG>Min(</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>DaysSinceLastIncident)</STRONG></SPAN></P></BODY></HTML> Thu, 19 Nov 2015 20:11:02 GMT https://community.qlik.com/t5/QlikView/How-to-always-show-a-value/m-p/945432#M955386 sunny_talwar 2015-11-19T20:11:02Z