Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

FirstSortedValue With Max

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_CREATEDUSERMax Count
CLASent15
GOLChri35
LOIRame1
QUODani7
SESGeor

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.

10 Replies
Anil_Babu_Samineni

Is this you are expecting?

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
tresesco
MVP
MVP

I am getting 15

Capture.PNG

qlikview979
Specialist
Specialist

Are you expecting like this

PFA

Untitled.png

Anonymous
Not applicable
Author

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

Test1.jpg

I am not getting the name of the user.

tresesco
MVP
MVP

You need 'DISTINCT' like:

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

Capture.PNG

Anil_Babu_Samineni

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

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

Thanks Tresesco,

Now its working fine...