Rank Question

[Anonymous]

I am using Qliksense cloud now for two years and really love it, but still struggle figuring out the syntax in expressions.

Mys scenario, I run a sales organization and am trying  to get Qliksense to do Rank in sales. I have no problem doing this in a table. I have and its working perfectly.

I am trying to do the same thing in a KPI object, so when I choose one specific rep and all the data in the visualization changes so it shows that person's rank. The issue is when I do this with the same formula, and specifically choose one rep it always says they rank 1.

I know it is not searching against the other rankings  and I need help to figure out what I am missing,.

If anyone can help would be great.

here is the expression for rank in a table, how do change this to use in a KPI object when I select one rep and filter data on one rep.

Thanks

=aggr(rank(count(distinct(PACKAGE_ID))),AGENT_LAST_NAME)

[sunny_talwar · Accepted solution]

May be this:

=Aggr(Rank(Count(DISTINCT {<AGENT_LAST_NAME>} PACKAGE_ID)), AGENT_LAST_NAME)

[Anonymous]

The first one worked perfectly. Thanks so much! really appreciate it.

[Anonymous]

Since this was answered so fast, perhaps I can ask a second.

The same scenario as above except this time I am not measuring sales but volume, specially called UNITS, how to do I create the ranking when its based on volume vs a sale. Ie one sale could 10 units or 20 units or 9.324 etc etc

Thanks

[sunny_talwar]

May be this

=Aggr(Rank(Sum({<AGENT_LAST_NAME>} UNITS)), AGENT_LAST_NAME)

[Anonymous]

Excellent, really really appreciate it. Much thanks!

[Anonymous]

You were very helpful last time, hoping you can help again

have a table with sum of units as measure and sales reps by dimension. My goal is to have qliksense color by expression.

Specifically, I want the expression to find the top three values in sum of units and color it a different colour, say green.

anyone can help a newbie out with this task?

Much appreciated.

IF(Sum(UNITS)>=2000,'green()',if(sum(UNITS)<2000,'black()'))

Thanks

[Anonymous]

I don't want the word green I want the text to turn green color.

[sunny_talwar]

You want to color top 3 guys in Green(), right? May be this

If(Rank(Sum(UNITS)) < 4, Green(), Black())

[Anonymous]

Are they parenthesis? the two characters after the word green?