Growth Calculation incorrect in QlikSense

[ajinkyabhonsle]

Hi Guys,

This is rather a calculation error or mistake that I am making. Here are the details:

When I calculate Growth B in excel I get 65%. I calculate this as B/(B+A).

Quarter	Desktop	Mobile	Growth Mobile
2020/Q3	34,990,489	63,989,588	65%

When I use the same logic in QlikSense I get 59%. 

Quarter	Desktop	Mobile	Growth Mobile
2020/Q3	34,990,489	63,989,588	59%

I am calculating the Growth Mobile field in qliksense as follows:

Sum({CLASSIFIY = {'Mobile'}>}VALUE)
/
(
Sum({CLASSIFIY = {'Mobile'}>}VALUE)
+
Sum({CLASSIFIY = {'Desktop'}>}VALUE)
)

Dont know where I am going wrong.

Can anyone help?

[y_grynechko · Accepted solution]

Hey,

I checked it and not sure how you store the data but I did this:

load * Inline [
Quarter, VALUE, CLASSIFIY
2020/Q3, 34990489, Desktop
2020/Q3, 63989588, Mobile
];

And your calculation gives 65%

[ajinkyabhonsle]

Thank you. I figured what was the issue. I just missed a value in my dimension in set analysis.