topic Re: Max expression with aggregation function in QlikView

Max expression with aggregation function

tpteo2019 — Tue, 10 Sep 2019 10:05:52 GMT

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.

Re: Max expression with aggregation function

tpteo2019 — Tue, 10 Sep 2019 10:08:48 GMT

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

Re: Max expression with aggregation function

tpteo2019 — Wed, 11 Sep 2019 02:37:23 GMT

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,

Re: Max expression with aggregation function

Brett_Bleess — Mon, 23 Sep 2019 15:49:18 GMT

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