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?

[#2]

hello Antonio

well,it doesn't work 😞

[antoniotiman]

[anbu1984]

Dimension: OrderSpecificationDim_Key

Expression: FirstSortedValue(TypeCheekDim_Key,-adSanadId)

[#5]

hi

it doesnt work in my qlikview. i have attached it.

id order=orderspecification_key

[#6]

hello

it doesnt work in my qlikview file. i have attached it.

id order=orderspecification_key

[#7]

if you could correct it would you pls write it here?

[#8]

if you could correct it would you pls write it here?

[anbu1984]

Can you give [id order] where it is not working? What is expected value?

[#10]

id order is the field. orderspecification_key is just a name.

[anbu1984]

I mean can you give example from your QVW, for which id order you are not getting correct result for TypeCheekDim_Key