Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

Data looks different when loading from the publisher

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

1 Solution

Accepted Solutions
alec1982
Specialist II
Specialist II
Author

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!

View solution in original post

13 Replies
its_anandrjs

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.

erikzions
Creator
Creator

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.

alec1982
Specialist II
Specialist II
Author

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?

alec1982
Specialist II
Specialist II
Author

Hi,

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

Thxs,

Badr

its_anandrjs

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

alec1982
Specialist II
Specialist II
Author

Hi,

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

erikzions
Creator
Creator

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.

alec1982
Specialist II
Specialist II
Author

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

swuehl
MVP
MVP

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.