Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Consolidating Data from Multiple QLIKSENSE App?

Hi,

Can anyone throw light how we can consolidate data from multiple QlikSense App just like QVD in Qlikview in QlikSense ?

-Thanks

Neelofar

9 Replies

Re: Consolidating Data from Multiple QLIKSENSE App?

I'm afraid I don't understand what you're asking. Qlik Sense apps can load data from data sources. You can also use the script of an Qlik Sense app to store tables with data into qvd files. This is no different then in Qlikview. You can create a Qlik Sense app that creates qvd files and the create another Qlik Sense app that loads data from those qvd files. If that doesn't answer your question please explain in more detail what you want to know.


talk is cheap, supply exceeds demand
Not applicable

Re: Consolidating Data from Multiple QLIKSENSE App?

Hi Gysbert,

Thank you for a quick response

I'm interested more on how to create a qvd in qliksense directly.

I have a sql query which serves as data source for my app.

Can you guide me how to do the below mentioned.

"You can create a Qlik Sense app that creates qvd files and the create another Qlik Sense app that loads data from those qvd files"

-Thanks

Neelofar

Re: Consolidating Data from Multiple QLIKSENSE App?

see the online help


talk is cheap, supply exceeds demand
MVP
MVP

Re: Consolidating Data from Multiple QLIKSENSE App?

Hi,

You can create QVD using STORE command like below

Data:

SELECT * FROM TableName;

STORE Data INTO filepath:\\Data.qvd;

Now you can use this QVD in another in QS file like below

Data:

LOAD

*

FROM filepath:\\Data.qvd (qvd);

Hope this helps you.

Regards,

Jagan.

reddys310
Honored Contributor II

Re: Consolidating Data from Multiple QLIKSENSE App?

Hi Jammalamadugu,

You can use a single QVD in multiple Sense applications as well. There are no restrictions in doing so.

Thanks,

Sangram.

Not applicable

Re: Consolidating Data from Multiple QLIKSENSE App?

Hi Jagan,

Thankyou !! My select Query has more than two table with joins

Can I use the same format or Do I need different way in this scenario to save QVD file.

MVP
MVP

Re: Consolidating Data from Multiple QLIKSENSE App?

Hi,

You can use any select query with joins, group by order by or any valid query in SQL works in Qlikview.   Check below example

Data:

SELECT * FROM TableName1 T1, TableName2 T2

WHERE T1.Key = T2.Key;

STORE Data INTO filepath:\\Data.qvd;

Now you can use this QVD in another in QS file like below

Data:

LOAD

*

FROM filepath:\\Data.qvd (qvd);

Regards,

jagan.

Not applicable

Re: Consolidating Data from Multiple QLIKSENSE App?

Thank you Jagan

MVP
MVP

Re: Consolidating Data from Multiple QLIKSENSE App?

Hi,

If you got the answer please close this thread by giving Correct & Helpful answers to the posts which helps you.

Regards,

Jagan.

Community Browser