topic Show the dimension with min value in QlikView https://community.qlik.com/t5/QlikView/Show-the-dimension-with-min-value/m-p/661677#M241135 <HTML><HEAD></HEAD><BODY><P>Hello Guys !</P><P></P><P>I'm trying to show "Roteiro" with the min value of "TempoParado". What i'm doing is :</P><P>FirstSortedValue (Distinct (Roteiro), Aggr( sum(TempoParado), Roteiro))</P><P></P><P>Is returning me anything. It's not every day that I have data on the "Roteiro", then only if I select all "Roteiro" it shows me the script with less "TempoDeParada". If I dont select nothing, nothing returns to me, but I always want the lowest value. </P><P>What is happening then is that he sees all values​​, even when zero, and i need only when have soomething.</P><P></P><P>How to do it?</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 22 Sep 2014 13:21:02 GMT Anonymous 2014-09-22T13:21:02Z Show the dimension with min value https://community.qlik.com/t5/QlikView/Show-the-dimension-with-min-value/m-p/661677#M241135 <HTML><HEAD></HEAD><BODY><P>Hello Guys !</P><P></P><P>I'm trying to show "Roteiro" with the min value of "TempoParado". What i'm doing is :</P><P>FirstSortedValue (Distinct (Roteiro), Aggr( sum(TempoParado), Roteiro))</P><P></P><P>Is returning me anything. It's not every day that I have data on the "Roteiro", then only if I select all "Roteiro" it shows me the script with less "TempoDeParada". If I dont select nothing, nothing returns to me, but I always want the lowest value. </P><P>What is happening then is that he sees all values​​, even when zero, and i need only when have soomething.</P><P></P><P>How to do it?</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 22 Sep 2014 13:21:02 GMT https://community.qlik.com/t5/QlikView/Show-the-dimension-with-min-value/m-p/661677#M241135 Anonymous 2014-09-22T13:21:02Z