Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Another Weighted Average Question :)

Team - i need to create an expression that calculates the Weighted Value Contribution (column 2). I'm stuck!

Here are my expressions

1) Value Contribution (%) = Value Contribution ($) / Industry Size

2) Weighted Value Contribution = TOTAL of Weighted Value Contribution * Weighted by VC

3) Weighted by VC = Value Contribution ($) / TOTAL Value Contribution ($)

MARKETValue Contribution (%)Weighted Value ContributionValue Contribution ($)Weighted by VCIndustry Size
Cars1.7%0.8%$50.048%$3,000.0
Trucks4.0%0.3%$20.019%$500.0
Boats1.1%0.3%$22.021%$2,000.0
Planes1.2%0.2%$11.011%$900.0
Bkes20.0%0.0%$1.01%$5.0
28.0%1.6%$104.0100%$6,405.0

Many Thanks,

Brian

1 Reply
MVP
MVP

Another Weighted Average Question :)

Maybe it's a little to late for me this evening:

Weighted Value Contribution = TOTAL of Weighted Value Contribution * Weighted by VC

Here you define a value by referencing the value, isn't this a logical loop?

Or maybe TOTAL of Weighted Value Contribution is a constant, like 100% or 1, but then it will just be

Weighted Value Contribution = Weighted by VC * const.

and you would need to define the constant, but I don't think that's what you want.

Community Browser