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?

[antoniotiman]

Mana,

aggr() is Dimention and Sum() is expression

[#3]

i have uploaded the output of query i made on my fact table in sql server and the qlikview for the same order ids.

as you see in pictures qlikview shows the sum not the max.

[anbu1984]

It seems like you have not loaded data properly. I don't see 46 for TypeCheekDim_Key in sql queryscreenshot

EDIT: Table mentioned in qlikview script is [Darya Warehouse MSH 4]. There is different table used in sql query screenshot

[#5]

i have uploaded the output of query i made on my fact table in sql server and the qlikview for the same order ids.

as you see in pictures qlikview shows the sum not the max.

[antoniotiman]

Your only dimension is Aggr(if())
in Pivot Table and expression sum()

[#7]

[Darya Warehouse MSH 4] is one of the cubes which is created on  Darya Warehouse MSH.

so thre is no mistake in data load

[anbu1984]

As you can see below, table box shows only one row for selected Id Order. Data loaded in qlikview has summed value 46. Problem is in your Sql or source table

[anbu1984]

Your cube has summed values

[#10]

it didnt change

[antoniotiman]

In Aggr(If(TOTAL

after TOTAL add <IdOrder>