Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone throw light how we can consolidate data from multiple QlikSense App just like QVD in Qlikview in QlikSense ?
-Thanks
Neelofar
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.
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
see the online help
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.
Hi Jammalamadugu,
You can use a single QVD in multiple Sense applications as well. There are no restrictions in doing so.
Thanks,
Sangram.
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.
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.
Thank you Jagan
Hi,
If you got the answer please close this thread by giving Correct & Helpful answers to the posts which helps you.
Regards,
Jagan.