Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

chaitakc
New Contributor II

Values in Qliksense dashboard differ from my mysql

Hi,

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?

Thanks

4 Replies
drillnaut
Valued Contributor

Re: Values in Qliksense dashboard differ from my mysql

We would need to know more about the query in question and what the datastructure of your Qlik application looks like, as well as your Table.

Also keep in mind that if you using a table and you have your dollars value as measure, you will end up with a different number than if you have it as a dimension.

agigliotti
Honored Contributor II

Re: Values in Qliksense dashboard differ from my mysql

even better if you could provide a sample qvf file to see what you are saying.

chaitakc
New Contributor II

Re: Values in Qliksense dashboard differ from my mysql

Thanks for response. However the rates issue is kind of sorted

Employee
Employee

Re: Values in Qliksense dashboard differ from my mysql

I am not sure what "kind of sorted means".

Please clarify what ever question you still have, or mark the thread as answered if you no longer have an question.