Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

howto calculate index % of margin variation

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

6 Replies
Anonymous
Not applicable
Author

simone,

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

Marc.

Not applicable
Author

Hi Marc,

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

what-if.JPG

Many thanks in advance.

Cheers

Simone

Anonymous
Not applicable
Author

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

Marc.

Not applicable
Author

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

what-if-error.JPG

Anonymous
Not applicable
Author

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.

Not applicable
Author

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.