Market Evolution Index Calculation

[Anonymous]

I need to calculate a market evolution index (EI 2014) based on the following data:

The (EI 2014) for the subgroup "DIRECT ACTING ANTIVIRALS" is calculated as follows:

EI 2014 = (100 + % Growth Rate '14 for the Subgroup) / (100 + Total % Growth Rate '14) * 100      which is

EI 2014 = (100 + 13.47) / (100 +26.76) * 100 = 89

A value under 100 means that the subgroup is growing less than the overall market.

How can i accomplish this with an expression in Qlikview?

[swuehl]

That's hard to answer without knowing how your expressions look like.

Assuming the percentages are really percentages, i.e. 13.47% is 0.1347, and assuming your % growth rate 14 column is based on a field [% Growth '14] in the data model, your expression could look like

= (1 + Only([% Growth '14]) ) / (1 + Avg(TOTAL [% Growth '14])) * 100

Probably my assumptions are all wrong...

[MarcoWedel]

please post a sample application.

regards

Marco

[Anonymous]

Thanks Swuehl

The [% Growth '14] is a calculated column

[Anonymous]

Many thanks Marco

i will create a sample application as the original one is too big.

Regards.

[Anonymous]

Marco

Please find attached sample application.

Regards.

[manojkulkarni]

try to use TOTAL in first 2 expressions to get the Total Growth.

[#8]

Hi Christopher,

Try the below expression

=(100 +([% Growth '13]*100))/( (100 +((Sum (TOTAL {$<Year={2013},Month=>} QTY)/Sum (TOTAL{$<Year={2012},Month=>} QTY))-1)))*100

Regards

Anand

[#9]

Hi Christopher,

Try the below expression

=(100 +([% Growth '13]*100))/( (100 +((Sum (TOTAL {$<Year={2013},Month=>} QTY)/Sum (TOTAL{$<Year={2012},Month=>} QTY))-1)))*100

[#10]

Hi Christopher

Find the application with solution.

Regards,

Anand