topic Re: Calculate Nth distinct value of dimension in straight table in QlikView https://community.qlik.com/t5/QlikView/Calculate-Nth-distinct-value-of-dimension-in-straight-table/m-p/55962#M9288 <HTML><HEAD></HEAD><BODY><P>It doesn't matter, I've solved it myself!</P><P>If anyone is interested, instead of Area as a dimension, I used:</P><P>=if(Aggr(RowNo(TOTAL),Area)=n,Area)</P><P>where 'n' is an integer representing the nth instance of the dimension.</P></BODY></HTML> Wed, 20 Jun 2018 14:04:50 GMT Ben_P 2018-06-20T14:04:50Z Calculate Nth distinct value of dimension in straight table https://community.qlik.com/t5/QlikView/Calculate-Nth-distinct-value-of-dimension-in-straight-table/m-p/55961#M9287 <HTML><HEAD></HEAD><BODY><P>Hi everyone.</P><P></P><P>It's a bit of a strange request, but I'm hoping someone can help.</P><P>I have a table as below left, with a dimension limit showing the largest 3 Sum(Sales) values on the Sub-Area field. This gives me 3 entries per Area.</P><P>What I would like to do is to split this into separate tables for each value of Area (the three tables on the right). The values in the Area field may change, so I don't want to hard-code them. Essentially what I want is to be able to replicate the table on the left, but only where e.g. the value of the Area field is the second distinct value (in this case 'B') of Area. For simplicity we can assume that there will always be 3 distinct values of Area.</P><P>I'm assuming I can do something with aggr() and rank(, but I've had no success so far. Any assistance would be much appreciated!</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/205747_Capture.PNG" style="height: 148px; width: 620px;" /></P></BODY></HTML> Wed, 20 Jun 2018 13:41:10 GMT https://community.qlik.com/t5/QlikView/Calculate-Nth-distinct-value-of-dimension-in-straight-table/m-p/55961#M9287 Ben_P 2018-06-20T13:41:10Z Re: Calculate Nth distinct value of dimension in straight table https://community.qlik.com/t5/QlikView/Calculate-Nth-distinct-value-of-dimension-in-straight-table/m-p/55962#M9288 <HTML><HEAD></HEAD><BODY><P>It doesn't matter, I've solved it myself!</P><P>If anyone is interested, instead of Area as a dimension, I used:</P><P>=if(Aggr(RowNo(TOTAL),Area)=n,Area)</P><P>where 'n' is an integer representing the nth instance of the dimension.</P></BODY></HTML> Wed, 20 Jun 2018 14:04:50 GMT https://community.qlik.com/t5/QlikView/Calculate-Nth-distinct-value-of-dimension-in-straight-table/m-p/55962#M9288 Ben_P 2018-06-20T14:04:50Z