Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

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
Author

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

Gysbert_Wassenaar

see the online help


talk is cheap, supply exceeds demand
jagan
Luminary Alumni
Luminary Alumni

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.

reddy-s
Master II
Master II

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
Author

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.

jagan
Luminary Alumni
Luminary Alumni

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
Author

Thank you Jagan

jagan
Luminary Alumni
Luminary Alumni

Hi,

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

Regards,

Jagan.