topic Re: FirstSortedValue With Max in QlikView

FirstSortedValue With Max

Anonymous — Mon, 22 May 2017 05:51:24 GMT

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.

Re: FirstSortedValue With Max

Anil_Babu_Samineni — Mon, 22 May 2017 05:57:29 GMT

Is this you are expecting?

Re: FirstSortedValue With Max

tresB — Mon, 22 May 2017 06:02:05 GMT

I am getting 15

Re: FirstSortedValue With Max

qlikview979 — Mon, 22 May 2017 06:10:50 GMT

Are you expecting like this

PFA

Re: FirstSortedValue With Max

Anonymous — Mon, 22 May 2017 06:15:10 GMT

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.

Re: FirstSortedValue With Max

Anil_Babu_Samineni — Mon, 22 May 2017 06:16:58 GMT

I have used same, Nothing changes done AON.

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

Re: FirstSortedValue With Max

Anonymous — Mon, 22 May 2017 06:21:55 GMT

I am not getting the name of the user.

Re: FirstSortedValue With Max

tresB — Mon, 22 May 2017 06:28:25 GMT

You need 'DISTINCT' like:

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

Re: FirstSortedValue With Max

Anil_Babu_Samineni — Mon, 22 May 2017 06:28:29 GMT

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

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

Re: FirstSortedValue With Max

Anonymous — Mon, 22 May 2017 06:31:54 GMT

Thanks Tresesco,

Now its working fine...

Re: FirstSortedValue With Max

srishsum2017 — Tue, 23 May 2017 12:01:19 GMT

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.