topic Problem with two QVDs. in QlikView

Problem with two QVDs.

Thu, 25 Feb 2010 18:09:50 GMT

First sorry for my bad english..

now i start explaining my problem...

I have two qvd that cacth the data from a SQL server. Each qvd is made in a report, and all the data is correct...

But when I make a new report with these QVD something goes worng a the data change (i think). I have a one key that join the o tables of the QVDs. Some keys dissappears!!

thanks for all the help.

Problem with two QVDs.

boorgura — Thu, 25 Feb 2010 18:23:42 GMT

Can you please elaborate on the exact issue you are facing.

Any info about the data and format will be a lot helpful.

Thanks,

Rocky

Problem with two QVDs.

Fri, 26 Feb 2010 09:16:57 GMT

Sorry it can be possilbe, the data is important

but i will explain the most as posible...

i have 2 qvd, the first with sales, and the second with the previsions.

so the relationship, between the sales and the prevision is a prevision could have 0 to N sales Associated.

and in the union of the two qvd, some data change...

For wexample..

I have a union field called KEY. in the two QVD this field is correct but in the union, some fields saids me that the don´t have associated data.

I load the qwd simple ...

Directory;

PREVISIONS.qvd(qvd);

Directory;

VFCajaLineas:

LOAD KEY, all the fields

FROM

SALES.qvd (qvd)

FROM

LOAD KEY, all the fields

Prevision:

Sorry but i dont know how to explain me.