Discussion Board for collaboration related to QlikView App Development.
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.
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,