Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Varaince in the data in qvd data and script data

Hi,

In one of my application I am loading the data from 3 databases. So everytime to refresh the data it was taking lot of time. To avoid the wastage of time in loading the data I have created 3 qvw which behaves as a qvd extractor. In the main application I am loading the data from these qvd's instead of loading directly from the databases.

But the problem I noticed here is that in one of the tab of the application in which data has been loaded from the qvd there is has been lots of difference in the data when compared to the application which has been loaded from the databases using the sql script.

I tried to look out is there is any difference in the script when compared to the sql/qvd but there is no difference found.

I am confused how to find for the error. Why there is mismatch in one of the tables.

Can anyone please help me out

6 Replies
Not applicable

Varaince in the data in qvd data and script data

Hi All,

Can anybody please help me out here as there is a mismatch in the data when compared to the qvd data and the script data though the script/column name are same in both the ends.

Can any one please help me out to find out the way to find the problem. I am confused why there is a change in the data though the script is same in both the ends.

Not applicable

Varaince in the data in qvd data and script data

Is it a date field?

Do all the 3 databases have same settings? in terms of collation....

to confirm, are you using 1 same script on 3 databases?

Not applicable

Varaince in the data in qvd data and script data

No it's different script and different databases! Got confused how to find the problem.

Not applicable

Varaince in the data in qvd data and script data

Hi.

Maybe in the main application there are relations between tables which then intersecting the data you get from this problematic QVD?

Not applicable

Varaince in the data in qvd data and script data

Main application also contains the same script. There is no other tables exists for intersecting the data. I am not able to find out where the issue is.

Not applicable

Varaince in the data in qvd data and script data

It´s very hard for us to reproduce based on this little info.

Can you in some way explain how we could reproduce it?

Community Browser