topic Top N in QlikView https://community.qlik.com/t5/QlikView/Top-N/m-p/891091#M310425 <HTML><HEAD></HEAD><BODY><P>I have a slider dimension that drives the variable vTopPhysicians and limits one result set to the top N Physician's using a dimension limit.&nbsp; </P><P></P><P>The second part i'm attempting to limit my express results to the Top N using the following:</P><P></P><P>SUM({&lt;ProcedureSurgeonName = {"=RANK(COUNT(DISTINCT SurgicalCaseSk),$(vTopPhysicians)-1)"}&gt;}SurgicalUsedQTY)</P><P></P><P>My Syntax shows it's correct, but it's not working correctly. </P></BODY></HTML> Wed, 24 Jun 2015 13:34:01 GMT NickHoff 2015-06-24T13:34:01Z Top N https://community.qlik.com/t5/QlikView/Top-N/m-p/891091#M310425 <HTML><HEAD></HEAD><BODY><P>I have a slider dimension that drives the variable vTopPhysicians and limits one result set to the top N Physician's using a dimension limit.&nbsp; </P><P></P><P>The second part i'm attempting to limit my express results to the Top N using the following:</P><P></P><P>SUM({&lt;ProcedureSurgeonName = {"=RANK(COUNT(DISTINCT SurgicalCaseSk),$(vTopPhysicians)-1)"}&gt;}SurgicalUsedQTY)</P><P></P><P>My Syntax shows it's correct, but it's not working correctly. </P></BODY></HTML> Wed, 24 Jun 2015 13:34:01 GMT https://community.qlik.com/t5/QlikView/Top-N/m-p/891091#M310425 NickHoff 2015-06-24T13:34:01Z Re: Top N https://community.qlik.com/t5/QlikView/Top-N/m-p/891092#M310426 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">SUM(</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">{&lt;</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">ProcedureSurgeonName = {"=RANK(COUNT(DISTINCT SurgicalCaseSk))&lt;($(vTopPhysicians)-1)"}&gt;}SurgicalUsedQTY)</SPAN></P></BODY></HTML> Wed, 24 Jun 2015 13:44:40 GMT https://community.qlik.com/t5/QlikView/Top-N/m-p/891092#M310426 MK_QSL 2015-06-24T13:44:40Z