Max expression with aggregation function

[tpteo2019]

Hi All,

I am new to analytical tools (qlikview and spotfire).

Can anyone expert from this community advise me what is below qlikview expression syntax.

Sum (CC_DURATION_ID)/Max(total<BRAND_MODEL>aggr(Sum (CC_DURATION_ID),BRAND_MODEL))

and what will be the right expression to write this into spotfire.

I do attach my table and data value for this report purpose.

Thanks in advance for your advise.

[tpteo2019]

PLANT_ID	CC_LABEL	CC_DURATION_ID
1	EqpCommOffline	200
1	DC=EqpCommOffline	5000
2	DC=CMMS: WO	600
2	DC=Change lot	70
7	DC=CMMS: WO	400
7	DC=EqpCommOffline	1000

[tpteo2019]

Hi All,

I repost the qlikview correct expression as below, should "PLANT_ID" instead of "BRAND_MODEL".

Sum (CC_DURATION_ID)/Max(total<PLANT_ID>aggr(Sum (CC_DURATION_ID),PLANT_ID))

Thanks & Regards,

[Brett_Bleess]

It is likely going to be most helpful if you can post your QVW file, or an example file that people can then see your data model as well as charts and expressions to figure out what you need in this case.  I believe you may have also confused some viewers by stating you were looking for Spotfire expression, if that is truly the case, you should be posting to their forum, not ours...  If you can provide further clarification on exactly what you need and an example QVW, I expect someone may be able to help you in that case.

Regards,
Brett