howto calculate index % of margin variation

[#1]

Dear all,

at the moment I don't understand how to set expression for calculating index % of margin in linear table graph.

In particolar my goal is calculate the distributions % of variation. Enclosed you can find out an example of my goal.

Note: I'm using a bookmark as based selection before calculate sales and what-if.

Any advice or comment is very appreciated.

thank you very much

Simone

[Anonymous]

simone,

Could you post the expected output to better understand your requirement, please?

Marc.

[#3]

Hi Marc,

my goal is show in var. index % as described in excel.

Many thanks in advance.

Cheers

Simone

[Anonymous]

ok, then your expression is ok, except of a bracket ) missing at the end.

Marc.

[#5]

thank you for your feedback but I don't understand why the variation index % in qlik is always the same and variation is difference. #caosinmindmodeon

[Anonymous]

simone,

I asked and you described the index margin = margin / total margin.  In your sample data your margin is 2€ in all rows, then you will obtain the same index margin. In the excel screenshot you posted before the margin (€) were different, and you got different index margins as well.

Marc.

[#7]

I resolved the issue since the incidence % is based on margin(i)/sum(total Sales).

Thank you very much, Marc.

Have a nice day.

S.