max in condition

[#1]

hi

i have table like this:

OrderSpecificationDim_Key	TypeCheekDim_Key	adSanadId
1391002317	20	26886
1391002317	3	29402
1391002318	20	26888
1391002319	20	26890
1391002319	23	29611
1391002320	3	51628
1391002320	23	29609
1391002320	20	26892

i need too show TypeCheekDim_Key for any OrderSpecificationDim_Key forthe max value of adSanadId

for example when OrderSpecificationDim_Key=1391002320 i should show 3 because it has the biggest value of adSanadId. i have wrote :

if ( (Aggr(max([Ad Sanad Id]),[Id Order])=[Ad Sanad Id]),[Type Check Dim Key],0 )

but it is not true it seem. any one can help me?

[anbu1984]

=FirstSortedValue(TypeCheekDim_Key,-adSanadId)

[#3]

hi anbu

it doesn't work

[JonnyPoole]

In this example, i'm using a chart expression to filter for just the records for the largest adSanaid within OrderSpecificationDim_Key

[anbu1984]

Can you post sample qvw. Check my qvw

[#6]

hello jonathan

sorry i cant open it because of license limitations, would you please write the code here?

[JonnyPoole]

Add the OrderSpecificationDim_Key and adSanadId  field   as dimensions in a straight table and then add an expression with this formula :

if ( max( total <OrderSpecificationDim_Key> adSanadId) =adSanadId , TypeCheekDim_Key)

and the load script was nothing special:

LOAD OrderSpecificationDim_Key,

     TypeCheekDim_Key,

     adSanadId

FROM

[http://community.qlik.com/thread/137133]

(html, codepage is 1252, embedded labels, table is @1);

[antoniotiman]

Hi Mana,

see attachment.

Regards,

Antonio

[#9]

hello Antonio

sorry i cant open it because of license limitations, would you please write the code here?

[antoniotiman]

I have used calculated dimension :

=Aggr(If(Max(TOTAL adSanadId)=adSanadId,OrderSpecificationDim_Key),OrderSpecificationDim_Key,adSanadId,TypeCheekDim_Key)