Subtract two percentages from each other - Page 2 - Qlik Community

stevietm · ‎2014-10-29

Hi All,

I would just like to know if it is possible to subtract two percentages from each other in a straight table. For example i have 3 columns that uses MAT variables to calculate MAT MS in %. First column = MAT-2 MS%, second column = MAT-1 MS% and third column = CY MAT MS%.

So what i want is to subtract MAT-1 MS% from MAT-2 MS%. Example below.

MS MAT -2	MS MAT -1	% Subtracted
29.68%	31.25%	1.57%
0.00%	3.06%	3.06%
13.03%	12.33%	-0.70%

I have tried to use the variables and subtract them from each other but its not giving me the growth or decline between the 2 percentages.

If someone knows how to do this please let me know.

Thanks in advance.

Regards

Stevie

Kushal_Chawda · ‎2014-10-30

Please see the attached file

stevietm · ‎2014-10-30

Hi Guys,

Please see new screen shot - hope this makes sense. Its the best i can explain what i want to see.

Thanks

Regards

Stevie

simondachstr · ‎2014-10-30

Can you upload a sample app with scrambled data? This looks fishy..

stigchel · ‎2014-10-30

I agree that the Column(4)-Column(3) should give the correct results, can you check whether you have marked this expression to be relative? If so, please uncheck the Relative checkbox for this expression.