topic min value using indirect set analysis in QlikView https://community.qlik.com/t5/QlikView/min-value-using-indirect-set-analysis/m-p/166207#M38231 <HTML><HEAD></HEAD><BODY><P></P><P></P><P>=ONLY({1&lt;[IPSM Year &amp; Month_mm] = {'$(=min([IPSM Year &amp; Month_mm]))'}&gt;} [IPSM Year &amp; Month])</P><BR /><BR /> <BR /><BR /></BODY></HTML> Wed, 12 Jan 2011 17:34:30 GMT 2011-01-12T17:34:30Z min value using indirect set analysis https://community.qlik.com/t5/QlikView/min-value-using-indirect-set-analysis/m-p/166206#M38230 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>Hopefully this is an easy one.....</P><P>My dimensions are:</P><P><EM>Year</EM> (2009, 2010 etc.)</P><P><EM>Year &amp; Month</EM> (2009 Jan, 2009 Feb etc.)</P><P><EM>Year &amp; Month_mm</EM> (2009 01, 2009 02 etc.)</P><P>When a user selects from <EM>Year,</EM> I want the min of <EM>Year &amp; Month</EM> to be displayed. I can't use min(<EM>Year &amp; Month)</EM> because it's a text field, I can't use minstring(<EM>Year &amp; Month)</EM> because it always returns xxxx Apr.</P><P>Is it possible to use indirect set analysis using the min of <EM>Year &amp; Month_mm</EM> but return the value from <EM>Year &amp; Month?</EM></P><P>I'm having a complete mind-block on this one so hopefully someone will provide the solution.</P><P>Many thanks.</P></BODY></HTML> Wed, 12 Jan 2011 17:16:41 GMT https://community.qlik.com/t5/QlikView/min-value-using-indirect-set-analysis/m-p/166206#M38230 2011-01-12T17:16:41Z min value using indirect set analysis https://community.qlik.com/t5/QlikView/min-value-using-indirect-set-analysis/m-p/166207#M38231 <HTML><HEAD></HEAD><BODY><P></P><P></P><P>=ONLY({1&lt;[IPSM Year &amp; Month_mm] = {'$(=min([IPSM Year &amp; Month_mm]))'}&gt;} [IPSM Year &amp; Month])</P><BR /><BR /> <BR /><BR /></BODY></HTML> Wed, 12 Jan 2011 17:34:30 GMT https://community.qlik.com/t5/QlikView/min-value-using-indirect-set-analysis/m-p/166207#M38231 2011-01-12T17:34:30Z