Discussion Board for collaboration related to Creating Analytics for QlikView.
A couldnt understand one thing - i have a connection to a *.mdb file, which has a tuned query ('index_all') (smth like average values gpopped by smth). If I execute this query in Access - i recieve a dataset. But, If i try to do this:
LIB CONNECT TO '*.mdb';
SQL SELECT `Avg-Avg-metr`,
I recieve dataset with slightly different values. (the structure is the same, but values are different!)
Why does it happen?
Thanx a lot!
In which kind are the values different? The values itself or the number of rows? Often it's helpful to compare directly certain records - maybe you have an ID or you creates a row-number. Within the load per rowno() and in select per https://599cd.com/tips/access/140703-row-number/.
the table from the screenshot is not the same as in the script.
It seems that there are more records by using OLE connect, so maybe some datas are filtered in Access?
Im sure i use one sourse - *.mdb file
Really - table on the first picture is forming by query called "index_all"
the second pic - table in Qlik Sense, formed by downloading data directly from "index_all" from that mdb file without any conditions ... - i havnt change the structure of that query.
I would suggest you make a copy of the query and simplify it, remove aggregations, so you see the underlying records, and see if you can spot which rows are different.
Things I would look out for are for example dates or decimal numbers stored in text fields, which could be interpreted differently if the query is run with different regional settings in the two different programs, or maybe null values.