topic Re: Know maximum item in QlikView https://community.qlik.com/t5/QlikView/Know-maximum-item/m-p/438197#M163358 <HTML><HEAD></HEAD><BODY><P>=<SPAN style="color: #0000ff; font-size: 8pt;">maxstring</SPAN><SPAN style="font-size: 8pt;">({&lt;PurchaseCost</SPAN><SPAN style="font-size: 8pt;">={</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(=max(PurchaseCost))</EM></STRONG><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Item_name</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Regards</SPAN></P><P><SPAN style="font-size: 8pt;">Raj</SPAN></P><P></P></BODY></HTML> Tue, 25 Sep 2012 11:25:56 GMT 2012-09-25T11:25:56Z Know maximum item https://community.qlik.com/t5/QlikView/Know-maximum-item/m-p/438195#M163356 <HTML><HEAD></HEAD><BODY><P>Dear grus!!</P><P></P><P>my question is so simple but i m not able to solve it.....</P><P></P><P>I have created line graph with item_name as dimension and sum(purshase cost) as expression </P><P>I have sort this graph decending.</P><P>so i am getting one of the item in top (let say computer)</P><P></P><P>now i want to show/highlight the name of that item (computer) which has highest cost in text box.</P><P></P><P>what would be the expresion in text box.?</P></BODY></HTML> Tue, 25 Sep 2012 10:15:31 GMT https://community.qlik.com/t5/QlikView/Know-maximum-item/m-p/438195#M163356 2012-09-25T10:15:31Z Re: Know maximum item https://community.qlik.com/t5/QlikView/Know-maximum-item/m-p/438196#M163357 <HTML><HEAD></HEAD><BODY><P>Hm,</P><P></P><P>One way of doing it, which might be overkill is:</P><P></P><P>=maxstring(aggr(dual(item_name, sum(PurchaseCost)), item_name))</P></BODY></HTML> Tue, 25 Sep 2012 10:29:03 GMT https://community.qlik.com/t5/QlikView/Know-maximum-item/m-p/438196#M163357 Anonymous 2012-09-25T10:29:03Z Re: Know maximum item https://community.qlik.com/t5/QlikView/Know-maximum-item/m-p/438197#M163358 <HTML><HEAD></HEAD><BODY><P>=<SPAN style="color: #0000ff; font-size: 8pt;">maxstring</SPAN><SPAN style="font-size: 8pt;">({&lt;PurchaseCost</SPAN><SPAN style="font-size: 8pt;">={</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(=max(PurchaseCost))</EM></STRONG><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Item_name</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Regards</SPAN></P><P><SPAN style="font-size: 8pt;">Raj</SPAN></P><P></P></BODY></HTML> Tue, 25 Sep 2012 11:25:56 GMT https://community.qlik.com/t5/QlikView/Know-maximum-item/m-p/438197#M163358 2012-09-25T11:25:56Z Re: Know maximum item https://community.qlik.com/t5/QlikView/Know-maximum-item/m-p/438198#M163359 <HTML><HEAD></HEAD><BODY><P>thnks for answer its work perfectly fine..... u rocks</P></BODY></HTML> Wed, 26 Sep 2012 10:07:33 GMT https://community.qlik.com/t5/QlikView/Know-maximum-item/m-p/438198#M163359 2012-09-26T10:07:33Z Re: Know maximum item https://community.qlik.com/t5/QlikView/Know-maximum-item/m-p/438199#M163360 <HTML><HEAD></HEAD><BODY><P>@arjuun</P><P></P><P>u also right but it is giving me item having highest purchasing cost did not apply on sum(prucshasing_cost)..</P><P>well thans to u also</P></BODY></HTML> Wed, 26 Sep 2012 10:08:53 GMT https://community.qlik.com/t5/QlikView/Know-maximum-item/m-p/438199#M163360 2012-09-26T10:08:53Z