Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

nagarjuna123
New Contributor II

How to get Rank in Dimension level

HIi,

I have a count of meetinigId and ClientName and Date fields .

How to get rank Based on the meetingId and Client Name in Dimension level.

Thanks,

10 Replies
MVP
MVP

Re: How to get Rank in Dimension level

Your requirement isn't very clear... would you be able to share a sample? Or try something like this

Aggr(Rank(Count(meetingId)), meetingId, [Client Name])

Re: How to get Rank in Dimension level

Don't create duplicate for single issue - Re: How to get Count in Pivot table

nagarjuna123
New Contributor II

Re: How to get Rank in Dimension level

How to get rank?

Re: How to get Rank in Dimension level

Provide sample as request by Sunny

nagarjuna123
New Contributor II

Re: How to get Rank in Dimension level

When i was trying above expr in dimension level it's getting all Clintname is 'First rank 'only.

And How to sort in Ranks in Dimension level in pivot table.

I tried (=aggr(rank(Count([Meeting Id]),1,1),[Client Name])).

MVP
MVP

Re: How to get Rank in Dimension level

Won't know unless you share a sample or an image or something which can help us show your issue

nagarjuna123
New Contributor II

Re: How to get Rank in Dimension level

Hi Sunny,

Sample Data

Date ,Client Name ,no of meeting, Rank

12/12/2016, XYZ,100,2

12/01/2017, YXZ,200,1

01/02/2017,ABC,75,3

Like this.....

How to get RAnk with in Sort order in Dimension leve in Pivot table

Thanks

MVP
MVP

Re: How to get Rank in Dimension level

Your calculated dimension looks okay to me

Capture.PNG

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.

nagarjuna123
New Contributor II

Re: How to get Rank in Dimension level

Hi Sunny ,

When i put above expression in Rank output getting like this.....

Rank

12

13-17

187-198

316-321

Thanks