topic Re: Data looks different when loading from the publisher in QlikView

Data looks different when loading from the publisher

alec1982 — Fri, 13 Jun 2014 14:17:06 GMT

Hi all,

I am facing a weird issue. When I load the dashboard locally it gives me all the data while on loading from the publisher it seems to miss some data..

The source documents directory is the same directory.

Any idea?

Thxs,

Alec

Re: Data looks different when loading from the publisher

its_anandrjs — Fri, 13 Jun 2014 14:25:44 GMT

1. Your Data Model has any joins which i believe when loading from publisher not get proper data due to any joins then the records get missed.

2. May be your dash board depends on the table where it is not refreshed and the thats reason data not updated in other case from the direct load it will loaded check the dependencies in the publisher.

Re: Data looks different when loading from the publisher

erikzions — Fri, 13 Jun 2014 14:28:53 GMT

I had the same thing a few weeks back. Turned out to be a section access issue. I had some bad data loading, and since I was only a user on Access Point the issue was presented.

Re: Data looks different when loading from the publisher

alec1982 — Fri, 13 Jun 2014 14:30:48 GMT

Hi,

I am using one source for both the publisher and the local. in fact I tried to load reload the document on the server locally and I got the data.

What do you mean by Dependencies in the publisher?

Re: Data looks different when loading from the publisher

alec1982 — Fri, 13 Jun 2014 14:32:22 GMT

Hi,

I don't have any sections access setup on this dashboard. it is so weird

Thxs,

Badr

Re: Data looks different when loading from the publisher

its_anandrjs — Fri, 13 Jun 2014 14:33:05 GMT

Hi Alec,

Thats what i am suggest same as Erik may be you have section access and due to the joins the key is not loaded for that person or from another desktop you load the same application. Try to get loaded this application from different system if you have permissions for that then you find the problem.

Regards

Re: Data looks different when loading from the publisher

alec1982 — Fri, 13 Jun 2014 14:35:25 GMT

Hi,

No section access. I have tried to load the dashboard manually on my PC and it works.

Re: Data looks different when loading from the publisher

erikzions — Fri, 13 Jun 2014 15:22:58 GMT

Check your keys. It is possible that any autonumbering might be seeded different.

Or..... Are you doing any direct SQL in your load. I have found that my local ODBC sometimes resolves the same SQL different than one on a server.

Re: Data looks different when loading from the publisher

alec1982 — Fri, 13 Jun 2014 15:45:40 GMT

hi guys,

I found the reason but don't know how to fix.

The exchange rates for part of data are scientific notation nrs such as 1.6853746029331113E-2

While the local QlikView application is recognizing the the value and changing it to regular nr the server is not..

Any idea on how to fix?

Thxs,

Alec

Re: Data looks different when loading from the publisher

swuehl — Fri, 13 Jun 2014 16:20:29 GMT

Alec, are you using 11.20 SR5 or later? Please have a look at the release notes:

Bug: 65030 Mixed Values with values like 1E4 are mismatched

When loading text fields QlikView has always tried to interpret numeric values and load them as

numeric, not text. Due to two different bugs the behavior of QlikView interpretation of exponential

numbers, nnnEn or nnnDn, has changed between releases. The safest way to make sure you get the

interpretation you like has always been to cast the specific fields to the right type in the script.

For customers with many old scripts affected by the behavior change, it has been decided to implement a

solution which allows a small degree of control of how QlikView will interpret text fields at script level.

A script variable 'ExponentNumberNotation' has been introduced. It can be assigned:

0 meaning neither 1.23E6 nor 1.23D6 is interpreted as an exponential number

1 meaning 1.23E6 but not 1.23D6 is interpreted as an exponential number

2 meaning both 1.23E6 and 1.23D6 are interpreted as an exponential number

If not assigned a value in the script, 1 will be the default value.

Re: Data looks different when loading from the publisher

alec1982 — Fri, 13 Jun 2014 16:29:19 GMT

Hi Swuehl,

The server version is 11.0.11440.0

I am not following how can I use the function if it is usable on my version. Would you please provide a sample and thxs fore all your help

Re: Data looks different when loading from the publisher

Bill_Britt — Fri, 13 Jun 2014 19:48:23 GMT

Hi,

If this is your issue, you will have to upgrade to be able to use this. There was not a patch release for 11.00

Bill

Re: Data looks different when loading from the publisher

alec1982 — Mon, 16 Jun 2014 14:24:45 GMT

I fixed the issue by changing the format on the source table but I am really disappointed with QlikView not able to change the format. I think if Excel can do it then QlikView should do it.

Thxs for all your help guys!

Re: Data looks different when loading from the publisher

Bill_Britt — Mon, 16 Jun 2014 14:27:33 GMT

Hi Alec1982,

If you are on the current release then the issue would be corrected with a switch. So, yes QlikView can do it.

Bill