topic Calculate the top 10 value in QlikView https://community.qlik.com/t5/QlikView/Calculate-the-top-10-value/m-p/1318182#M408888 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>I am using the expression for calculating the count for a percentage. </P><P>The below expression is working fine.</P><P></P><P><SPAN style="color: #3366ff;">=if([Rolling_7_days.File Date1]='$(VRollCurrentday)',</SPAN></P><P><SPAN style="color: #3366ff;">Rangemax((Sum(Rolling_7_days.Counts)-above(TOTAL sum( Rolling_7_days.Counts ) ))/above(TOTAL sum( Rolling_7_days.Counts ) ),'#,##0.00',0))</SPAN></P><P></P><P>but I need top 10 value based on the above expression could you please add the logic in my expression, so that i can get top 10 value in the below screenshot.</P><P><IMG alt="TGB.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/170393_TGB.jpg" style="height: auto;" /></P><P>Thanks,</P><P>Irshad Ahmad</P></BODY></HTML> Mon, 17 Jul 2017 10:24:38 GMT iahmadmca1 2017-07-17T10:24:38Z Calculate the top 10 value https://community.qlik.com/t5/QlikView/Calculate-the-top-10-value/m-p/1318182#M408888 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>I am using the expression for calculating the count for a percentage. </P><P>The below expression is working fine.</P><P></P><P><SPAN style="color: #3366ff;">=if([Rolling_7_days.File Date1]='$(VRollCurrentday)',</SPAN></P><P><SPAN style="color: #3366ff;">Rangemax((Sum(Rolling_7_days.Counts)-above(TOTAL sum( Rolling_7_days.Counts ) ))/above(TOTAL sum( Rolling_7_days.Counts ) ),'#,##0.00',0))</SPAN></P><P></P><P>but I need top 10 value based on the above expression could you please add the logic in my expression, so that i can get top 10 value in the below screenshot.</P><P><IMG alt="TGB.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/170393_TGB.jpg" style="height: auto;" /></P><P>Thanks,</P><P>Irshad Ahmad</P></BODY></HTML> Mon, 17 Jul 2017 10:24:38 GMT https://community.qlik.com/t5/QlikView/Calculate-the-top-10-value/m-p/1318182#M408888 iahmadmca1 2017-07-17T10:24:38Z