Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

mystically different values?

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!

8 Replies
MVP & Luminary
MVP & Luminary

Re: mystically different values?

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

Not applicable

Re: mystically different values?

Thaks for your reply!

Different values by meanings - see below:

access.pngsense.png

Not applicable

Re: mystically different values?

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. 

Partner
Partner

Re: mystically different values?

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?

mov
Esteemed Contributor III

Re: mystically different values?

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

MVP & Luminary
MVP & Luminary

Re: mystically different values?

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

- Marcus

Not applicable

Re: mystically different values?

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.

Not applicable

Re: mystically different values?

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.