Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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%
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%
Thank you. I figured what was the issue. I just missed a value in my dimension in set analysis.