topic Re: How to get Rank in Dimension level in App Development https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438555#M34675 <HTML><HEAD></HEAD><BODY><P>Provide sample as request by Sunny</P></BODY></HTML> Wed, 06 Dec 2017 12:26:28 GMT Anil_Babu_Samineni 2017-12-06T12:26:28Z How to get Rank in Dimension level https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438551#M34671 <HTML><HEAD></HEAD><BODY><P>HIi,</P><P></P><P>I have a count of meetinigId and ClientName and Date fields .</P><P></P><P>How to get rank Based on the meetingId and Client Name in Dimension level.</P><P></P><P>Thanks,</P></BODY></HTML> Wed, 06 Dec 2017 12:15:53 GMT https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438551#M34671 Anonymous 2017-12-06T12:15:53Z Re: How to get Rank in Dimension level https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438552#M34672 <HTML><HEAD></HEAD><BODY><P>Your requirement isn't very clear... would you be able to share a sample? Or try something like this</P><P></P><P>Aggr(Rank(Count(meetingId)), meetingId, [Client Name])</P></BODY></HTML> Wed, 06 Dec 2017 12:18:25 GMT https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438552#M34672 sunny_talwar 2017-12-06T12:18:25Z Re: How to get Rank in Dimension level https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438553#M34673 <HTML><HEAD></HEAD><BODY><P>Don't create duplicate for single issue - <A href="https://community.qlik.com/message/1396098">Re: How to get Count in Pivot table</A></P></BODY></HTML> Wed, 06 Dec 2017 12:20:25 GMT https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438553#M34673 Anil_Babu_Samineni 2017-12-06T12:20:25Z Re: How to get Rank in Dimension level https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438554#M34674 <HTML><HEAD></HEAD><BODY><P>How to get rank?</P></BODY></HTML> Wed, 06 Dec 2017 12:25:16 GMT https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438554#M34674 Anonymous 2017-12-06T12:25:16Z Re: How to get Rank in Dimension level https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438555#M34675 <HTML><HEAD></HEAD><BODY><P>Provide sample as request by Sunny</P></BODY></HTML> Wed, 06 Dec 2017 12:26:28 GMT https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438555#M34675 Anil_Babu_Samineni 2017-12-06T12:26:28Z Re: How to get Rank in Dimension level https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438556#M34676 <HTML><HEAD></HEAD><BODY><P>When i was trying above expr in dimension level it's getting all Clintname is 'First rank 'only.</P><P></P><P>And How to sort in Ranks in Dimension level in pivot table.</P><P></P><P>I tried (=aggr(rank(Count([Meeting Id]),1,1),[Client Name])). </P></BODY></HTML> Wed, 06 Dec 2017 12:38:49 GMT https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438556#M34676 Anonymous 2017-12-06T12:38:49Z Re: How to get Rank in Dimension level https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438557#M34677 <HTML><HEAD></HEAD><BODY><P>Won't know unless you share a sample or an image or something which can help us show your issue</P></BODY></HTML> Wed, 06 Dec 2017 12:48:47 GMT https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438557#M34677 sunny_talwar 2017-12-06T12:48:47Z Re: How to get Rank in Dimension level https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438558#M34678 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>Sample Data </P><P>Date ,Client Name ,no of meeting, Rank</P><P>12/12/2016, XYZ,100,2</P><P>12/01/2017, YXZ,200,1</P><P>01/02/2017,ABC,75,3</P><P></P><P>Like this.....</P><P>How to get RAnk with in Sort order in Dimension leve in Pivot table</P><P></P><P></P><P></P><P>Thanks</P></BODY></HTML> Wed, 06 Dec 2017 12:55:31 GMT https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438558#M34678 Anonymous 2017-12-06T12:55:31Z Re: How to get Rank in Dimension level https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438559#M34679 <HTML><HEAD></HEAD><BODY><P>Your calculated dimension looks okay to me</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/185943_Capture.PNG" style="height: auto;" /></P><P></P><P>Here, I am guessing that you gave me a no of meeting as a field, where as you should have it as count(meetingid)... so if that is true, the calculated dimension looks good to me.</P></BODY></HTML> Wed, 06 Dec 2017 13:02:00 GMT https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438559#M34679 sunny_talwar 2017-12-06T13:02:00Z Re: How to get Rank in Dimension level https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438560#M34680 <HTML><HEAD></HEAD><BODY><P>Hi Sunny ,</P><P></P><P>When i put above expression in Rank output getting like this.....</P><P></P><P>Rank</P><P>12</P><P>13-17</P><P>187-198</P><P>316-321</P><P></P><P>Thanks</P></BODY></HTML> Thu, 07 Dec 2017 05:40:41 GMT https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438560#M34680 Anonymous 2017-12-07T05:40:41Z Re: How to get Rank in Dimension level https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438561#M34681 <HTML><HEAD></HEAD><BODY><P>No idea... unless you share an sample, I will have no idea <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 07 Dec 2017 12:19:28 GMT https://community.qlik.com/t5/App-Development/How-to-get-Rank-in-Dimension-level/m-p/1438561#M34681 sunny_talwar 2017-12-07T12:19:28Z