Values in Qliksense dashboard differ from my mysql
I am a new user to Qliksense. I have used a ODBC connection to connect mysql with Qliksense. I have used mysql query to extract the table values and export the results in excel file. When I use the same query in data load editor and connect my Qliksense dashboard , I see there are changes in the values for eg; if I sum up the values of the variable x it comes around 15 million $ in excel(using mysql query) but if I see the total of x in Qliksense it shows as 12 million $. What can be the issue?