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.

[srishsum2017]

        

Hi Bijay I tried same on front end and as well as back end but i got same result in both .

Please go through with the attached qvw for better understanding.