topic Re: Deduplicate and highest value in chart in QlikView https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916578#M468828 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">firstsortedvalue(Loss_nr,-Loss_nr)</SPAN></P><P>firstsortedvalue(Amount,-Loss_nr)</P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/95459_1.png" style="height: auto; width: auto;" /></P></BODY></HTML> Sun, 09 Aug 2015 16:05:34 GMT maxgro 2015-08-09T16:05:34Z Deduplicate and highest value in chart https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916576#M468826 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the following problem:</P><P></P><P>I have a table with "Poliy_nr", "Loss_nr" and "Amount":</P><P></P><P>The table is as following:</P><P></P><P><STRONG>Policy_nr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Loss_nr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount</STRONG></P><P>50899&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>50899&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.000&nbsp; </P><P>50899&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.000&nbsp; </P><P>12987&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.000</P><P>12987&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.000</P><P>81790&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.000</P><P>81790&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.000</P><P>81790&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.000</P><P>81790&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.000</P><P>81790&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.000</P><P>13343&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4.000</P><P>13343&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4.000</P><P></P><P>I just want the highest "Loss_nr" in eacht "Policy_nr".</P><P>The result must show the following:</P><P></P><P><STRONG>Policy_nr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Loss_nr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount</STRONG></P><P>50899&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.000&nbsp; </P><P>12987&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.000</P><P>81790&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.000</P><P>13343&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4.000</P><P></P><P>Hopefully somebody can help me how I can achieve this.</P><P>I am struggling this problem for days without any success.</P></BODY></HTML> Sun, 09 Aug 2015 13:24:47 GMT https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916576#M468826 Anonymous 2015-08-09T13:24:47Z Re: Deduplicate and highest value in chart https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916577#M468827 <HTML><HEAD></HEAD><BODY><P>hi </P><P>for loss_nr you can use a simple max </P><P>for the amount you can use firstsortedvalue(Amount,-Loss_nr)</P></BODY></HTML> Sun, 09 Aug 2015 14:17:45 GMT https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916577#M468827 lironbaram 2015-08-09T14:17:45Z Re: Deduplicate and highest value in chart https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916578#M468828 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">firstsortedvalue(Loss_nr,-Loss_nr)</SPAN></P><P>firstsortedvalue(Amount,-Loss_nr)</P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/95459_1.png" style="height: auto; width: auto;" /></P></BODY></HTML> Sun, 09 Aug 2015 16:05:34 GMT https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916578#M468828 maxgro 2015-08-09T16:05:34Z Re: Deduplicate and highest value in chart https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916579#M468829 <HTML><HEAD></HEAD><BODY><P>It might be a stupid question, but I am new to Qlikview. Could you please explain how I can use the "max" en if I have to do that in the script of priorities of the chart and on which tab. </P></BODY></HTML> Sun, 09 Aug 2015 18:08:52 GMT https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916579#M468829 Anonymous 2015-08-09T18:08:52Z Re: Deduplicate and highest value in chart https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916580#M468830 <HTML><HEAD></HEAD><BODY><P>I tried but without any success. Is it possible to send me an example in a qvw?</P></BODY></HTML> Sun, 09 Aug 2015 18:16:33 GMT https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916580#M468830 Anonymous 2015-08-09T18:16:33Z Re: Deduplicate and highest value in chart https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916581#M468831 <HTML><HEAD></HEAD><BODY><P>Like this!</P></BODY></HTML> Sun, 09 Aug 2015 18:33:40 GMT https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916581#M468831 Digvijay_Singh 2015-08-09T18:33:40Z Re: Deduplicate and highest value in chart https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916582#M468832 <HTML><HEAD></HEAD><BODY><P>It's a straight table chart with 1 dimension and the 2 expressions I posted,</P><P>you can find the chart in Digvijay Singh attachment (175884.qvw)</P><H6 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></H6></BODY></HTML> Sun, 09 Aug 2015 19:15:30 GMT https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916582#M468832 maxgro 2015-08-09T19:15:30Z Re: Deduplicate and highest value in chart https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916583#M468833 <HTML><HEAD></HEAD><BODY><P>Thanks a lot! It works. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sun, 09 Aug 2015 20:12:47 GMT https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916583#M468833 Anonymous 2015-08-09T20:12:47Z Re: Deduplicate and highest value in chart https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916584#M468834 <HTML><HEAD></HEAD><BODY><P>Thanks Massimo Grossi and Digvijay Singh, you both really helped me.</P><P>I am very happy to have the solution finely!</P></BODY></HTML> Sun, 09 Aug 2015 20:14:46 GMT https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916584#M468834 Anonymous 2015-08-09T20:14:46Z Re: Deduplicate and highest value in chart https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916585#M468835 <HTML><HEAD></HEAD><BODY><P>Gud, If you feel so please mark <A href="https://community.qlik.com/qlik-users/10670">maxgro</A>‌ 'response' as right answer <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> to close the thread. </P></BODY></HTML> Sun, 09 Aug 2015 20:27:40 GMT https://community.qlik.com/t5/QlikView/Deduplicate-and-highest-value-in-chart/m-p/916585#M468835 Digvijay_Singh 2015-08-09T20:27:40Z