topic Re: How we can consolidate or combine data from multiple qlikview applications with help of QVD's ?? in QlikView

How we can consolidate or combine data from multiple qlikview applications with help of QVD's ??

nikhilgarg — Fri, 05 Sep 2014 05:32:01 GMT

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.

Re: How we can consolidate or combine data from multiple qlikview applications with help of QVD's ??

ajaykumar1 — Fri, 05 Sep 2014 05:39:31 GMT

Hi ,

May be the question is like;

How we can consolidate the data from multiple qvds' to build the qlikview apps.

Re: How we can consolidate or combine data from multiple qlikview applications with help of QVD's ??

Anonymous — Fri, 05 Sep 2014 05:42:28 GMT

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.......

Re: How we can consolidate or combine data from multiple qlikview applications with help of QVD's ??

Fri, 05 Sep 2014 05:42:57 GMT

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!

Re: How we can consolidate or combine data from multiple qlikview applications with help of QVD's ??

tresB — Fri, 05 Sep 2014 05:45:48 GMT

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.