Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
With the help of QVD's , we can consolidate or combine data from multiple qlikview applications.
WHat does it means and how we can do it ??
Plese help.
Thanx.
Hi ,
May be the question is like;
How we can consolidate the data from multiple qvds' to build the qlikview apps.
Actually I didnot get your point.....
But as far as I understood, we can store the required QVDs and then using these QVDs in some other application we can combine or consolidae the data....
Example>>
QVW1>> Store Table into QVD1.qvd;
QVW2>> Store Table into QVD2.qvd;
QVW3> Load * from QVD1.qvd(qvd);
concatenate
Load * from QVD2.qvd(qvd);
In this way we are combining two QVDs that are being created by different QVWs.......
Hi
I think we can have something below
BINARY MYFILE.qvw;
FOR i = 0 to NoOfTables() -1
LET vTbNm = TableName($(i));
LET vFile = '$(vTbNm).qvd';
STORE [$(vTbNm)] INTO [$(vFile )] (qvd);
NEXT i
Please see we can have one binary load in script.
Thanks!
Store command helps you create qvds. From different qvws, you can create qvds (say, app1_qvd1, app1_qvd2, app2_qvd1, app2_qvd2) and then use them in another qvw (say, new.qvw) that uses qvds from both qvws. Should be simple like that. Now here in new qvw, you have to be careful of data modeling.