topic Re: howto calculate index % of margin variation in QlikView

howto calculate index % of margin variation

Wed, 04 Mar 2015 08:14:41 GMT

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

Re: howto calculate index % of margin variation

Anonymous — Wed, 04 Mar 2015 08:24:30 GMT

simone,

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

Marc.

Re: howto calculate index % of margin variation

Wed, 04 Mar 2015 08:51:44 GMT

Hi Marc,

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

Many thanks in advance.

Cheers

Simone

Re: howto calculate index % of margin variation

Anonymous — Wed, 04 Mar 2015 08:56:10 GMT

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

Marc.

Re: howto calculate index % of margin variation

Wed, 04 Mar 2015 09:10:13 GMT

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

Re: howto calculate index % of margin variation

Anonymous — Wed, 04 Mar 2015 09:51:35 GMT

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.

Re: howto calculate index % of margin variation

Wed, 04 Mar 2015 10:02:05 GMT

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

Thank you very much, Marc.

Have a nice day.