FirstSortedValue With Max

[Anonymous]

Hi All,

I am trying to get the max count and name fo first user.

Cany anyone help me in doing so.

1. Straight Table

2 Dimension: SYSTEM_CREATED

3 Expression1: FirstSortedValue(USER,-Aggr(COUNT(USER),USER,SYSTEM_CREATED))

4 Expression2: =Max(Aggr(Count(USER),USER,SYSTEM_CREATED))

SYSTEM_CREATED	USER	Max Count
CLA	Sent	15
GOL	Chri	35
LOI	Rame	1
QUO	Dani	7
SES	Geor	6

I am getting the result but CLA sent count is showing 16 which is incorrect.

2. When I am creating a list box Region on clicking the USA it not reflecting the name of User in the straight table.

[Anil_Babu_Samineni]

Is this you are expecting?

[tresesco]

I am getting 15

[qlikview979]

Are you expecting like this

PFA

[Anonymous]

Hi Anil,

R u using the same expression and dimension as I have used.

2nd have you create Region on clicking the USA did you the name of the user.

[Anil_Babu_Samineni]

I have used same, Nothing changes done AON.

Can you tell us expected result may be? If anything need ful

[Anonymous]

I am not getting the name of the user.

[tresesco]

You need 'DISTINCT' like:

FirstSortedValue(DISTINCT USER,-Aggr(COUNT(USER),USER,SYSTEM_CREATED))

[Anil_Babu_Samineni]

Could be the reason, You are aggregating two dimensions. May be try this?

FirstSortedValue(USER,-Aggr(COUNT(USER),SYSTEM_CREATED))

[Anonymous]

Thanks Tresesco,

Now its working fine...