Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Growth Calculation incorrect in QlikSense

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).

QuarterDesktopMobileGrowth Mobile
2020/Q3     34,990,489   63,989,58865%

 

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

QuarterDesktopMobileGrowth Mobile
2020/Q3     34,990,489   63,989,58859%
 

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?

1 Solution

Accepted Solutions
Creator III
Creator III

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%

Capture.PNG

View solution in original post

2 Replies
Creator III
Creator III

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%

Capture.PNG

View solution in original post

Highlighted
Contributor III
Contributor III

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