topic Top N set analysis in QlikView https://community.qlik.com/t5/QlikView/Top-N-set-analysis/m-p/883703#M308212 <HTML><HEAD></HEAD><BODY><P>I have a working set analysis expression that limits the population to the top N.&nbsp; However, my data model includes CalendarYear, CalendarMonth, and CalendarQuarter, but none of the calendar objects work with top N expression.&nbsp; How can I get Year, Month, and Quarter to work?</P><P></P><P>COUNT({&lt;ProcedureSurgeonName = {"=RANK(COUNT(DISTINCT SurgicalCaseSk),4)=1"}&gt;}DISTINCT SurgicalCaseSk)</P></BODY></HTML> Wed, 15 Jul 2015 18:02:05 GMT NickHoff 2015-07-15T18:02:05Z Top N set analysis https://community.qlik.com/t5/QlikView/Top-N-set-analysis/m-p/883703#M308212 <HTML><HEAD></HEAD><BODY><P>I have a working set analysis expression that limits the population to the top N.&nbsp; However, my data model includes CalendarYear, CalendarMonth, and CalendarQuarter, but none of the calendar objects work with top N expression.&nbsp; How can I get Year, Month, and Quarter to work?</P><P></P><P>COUNT({&lt;ProcedureSurgeonName = {"=RANK(COUNT(DISTINCT SurgicalCaseSk),4)=1"}&gt;}DISTINCT SurgicalCaseSk)</P></BODY></HTML> Wed, 15 Jul 2015 18:02:05 GMT https://community.qlik.com/t5/QlikView/Top-N-set-analysis/m-p/883703#M308212 NickHoff 2015-07-15T18:02:05Z Re: Top N set analysis https://community.qlik.com/t5/QlikView/Top-N-set-analysis/m-p/883704#M308213 <HTML><HEAD></HEAD><BODY><P>As per the expression (If it is working), Year, Quarter and Month selections should effect the data. So there might be something wrong in your data model.</P><P></P><P>Can you attach sample QVW and/or explain the set expression, dimensions on the chart etc?</P><P></P><P>Regards,</P><P>KKR</P></BODY></HTML> Thu, 16 Jul 2015 05:00:22 GMT https://community.qlik.com/t5/QlikView/Top-N-set-analysis/m-p/883704#M308213 2015-07-16T05:00:22Z Re: Top N set analysis https://community.qlik.com/t5/QlikView/Top-N-set-analysis/m-p/883705#M308214 <HTML><HEAD></HEAD><BODY><P>It was correct in the data model my problem was there was an alternate state selected on the calendar fields, which threw everything off.</P></BODY></HTML> Thu, 16 Jul 2015 13:20:11 GMT https://community.qlik.com/t5/QlikView/Top-N-set-analysis/m-p/883705#M308214 NickHoff 2015-07-16T13:20:11Z