Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

tpteo2019
New Contributor

Max expression with aggregation function

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.

 

2 Replies
tpteo2019
New Contributor

Re: Max expression with aggregation function

PLANT_IDCC_LABELCC_DURATION_ID
1EqpCommOffline200
1DC=EqpCommOffline5000
2DC=CMMS: WO600
2DC=Change lot70
7DC=CMMS: WO400
7DC=EqpCommOffline1000
tpteo2019
New Contributor

Re: Max expression with aggregation function

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,