topic Re: Help with Expressions please in QlikView https://community.qlik.com/t5/QlikView/Help-with-Expressions-please/m-p/385223#M1168080 <HTML><HEAD></HEAD><BODY><P>Create two charts. One with [Problem Code] dimension the other with [CallRef] (I guess its an individual).</P><P></P><P>And use this expression (in both charts):</P><P>=Min(aggr([Minutes Spent], [Problem Code], [CallRef])</P></BODY></HTML> Sat, 08 Sep 2012 12:20:15 GMT whiteline 2012-09-08T12:20:15Z Help with Expressions please https://community.qlik.com/t5/QlikView/Help-with-Expressions-please/m-p/385222#M1168079 <HTML><HEAD></HEAD><BODY><P>If I have a table containing data like this:</P><P><IMG __jive_id="21477" class="jive-image-thumbnail jive-image" onclick="" alt="pic3.png" src="https://community.qlik.com/legacyfs/online/21477_pic3.png" width="450" /></P><P>Please could someone tell me how to write expressions to show:</P><P></P><UL><LI>The fewest number of minutes spent by anyone on a Problem Code (please note that every time someone spends time on a call it creates a seperate entry, so I would need to sum the time spent for each call linked to the problem code and show the lowest sum) - looking for a team record.</LI><LI>The fewest number of minutes spent by the individual I am looking at on a Problem Code - looking for a personal best.</LI></UL><P></P><P>Thanks.</P></BODY></HTML> Fri, 07 Sep 2012 07:53:29 GMT https://community.qlik.com/t5/QlikView/Help-with-Expressions-please/m-p/385222#M1168079 2012-09-07T07:53:29Z Re: Help with Expressions please https://community.qlik.com/t5/QlikView/Help-with-Expressions-please/m-p/385223#M1168080 <HTML><HEAD></HEAD><BODY><P>Create two charts. One with [Problem Code] dimension the other with [CallRef] (I guess its an individual).</P><P></P><P>And use this expression (in both charts):</P><P>=Min(aggr([Minutes Spent], [Problem Code], [CallRef])</P></BODY></HTML> Sat, 08 Sep 2012 12:20:15 GMT https://community.qlik.com/t5/QlikView/Help-with-Expressions-please/m-p/385223#M1168080 whiteline 2012-09-08T12:20:15Z