topic Re: mystically different values? in QlikView

mystically different values?

Wed, 03 Jun 2015 10:08:36 GMT

Hi all!

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:

data_index:

LIB CONNECT TO '*.mdb';

LOAD `Avg-Avg-metr`,

`Avg-Avg-price`,

`Count-Avg-metr`,

`Max-data`,

`StDev-Avg-metr`;

SQL SELECT `Avg-Avg-metr`,

`Avg-Avg-price`,

`Count-Avg-metr`,

`Max-data`,

`StDev-Avg-metr`

FROM `index_all`;

I recieve dataset with slightly different values. (the structure is the same, but values are different!)

Why does it happen?

Thanx a lot!

Re: mystically different values?

marcus_sommer — Wed, 03 Jun 2015 12:21:18 GMT

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

- Marcus

Re: mystically different values?

Wed, 03 Jun 2015 13:47:04 GMT

Thaks for your reply!

Different values by meanings - see below:

Re: mystically different values?

Wed, 03 Jun 2015 13:49:50 GMT

Thats mystic! because what im doing - im executing the same query in Access or downloading the same by ole provider in Qlik Sense. The result MUST be the same.

Re: mystically different values?

martinpohl — Wed, 03 Jun 2015 13:54:01 GMT

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?

Re: mystically different values?

Anonymous — Wed, 03 Jun 2015 13:55:01 GMT

Are you sure you're reading from the same data source???

Re: mystically different values?

marcus_sommer — Wed, 03 Jun 2015 14:01:47 GMT

For me it looks that you are loading different versions from the data - maybe an old one and a newer one.

- Marcus

Re: mystically different values?

Wed, 03 Jun 2015 14:17:13 GMT

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.

Re: mystically different values?

Mon, 08 Jun 2015 10:11:20 GMT

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.