Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
I have a situation in which i have to merge the two qvds into one qvd by taking one of them as a base. The problem which i am facing is that the charts generate new chart ids every time whenever i copy them from 1 qvd to the other.
I have qvd 1 and qvd2. i need to merge them taking them qvd1 as a base. Data model for botj of them is same. How can i merge them quiclky??/
Other problem is that i have already written a macro for both of them and now when i try to merge them by copying chart from qvd2 to qvd1 the new chart id gets generated
Hi,
you are merging some different themes together, for explanation:
1. a qvd is a stored QlikView table. You can open it in a QVW by the script: LOAD * From Name.qvd (qvd);
2. You can always merge some QVDs with joining or concatenating them in script:
Data:
LOAD * From Name1.qvd (qvd);
Concatenate (Data)
LOAD * From Name2.qvd (qvd);
or
Data:
LOAD * From Name1.qvd (qvd);
Left Join (Data)
LOAD * From Name2.qvd (qvd);
3. You can enter a new ID by using the RowNo()
Data:
LOAD RowNo() As IDNew, * From Name1.qvd (qvd);
Concatenate (Data)
LOAD RowNo() As IDNew, * From Name2.qvd (qvd);
4. a chart is only possible in a QVW.
Greetings from Munich
Martina
sorry , i want to merge qvws not qvd
Hi
Do you perhaps mean QVWs?
A QVD is a Qlikview data file that contains only data, no charts. QVW is the Qlikview model file containing charts and other objects.
If you are manually copying charts from one to the other, it is easy enough to change the object ID. On the Properties | General tab for the chart, change the Object ID to be the same as the source document.
Jonathan
Hi Jonathan
I mean QVWS.
thnx for your solution. But this will take lots of time. I cant do this way. If there is an alternative plz tell me
Hi
I am afraid nothing else comes to mind. Perhaps someone else?
Regards
Jonathan