Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Has anybody tried using Qliksense qvf as a source in Qlikview ?
I want to extract tables present in the Qliksense cache.
I do not have Qliksense desktop installed on my system ( O.S doesn't support Qliksense) so can't install QS on my desktop
Nor can I point the Qliksense server to my local host,because if I could I would have used this qvf as a source for the Qliksense app deployed on the server.
Thanks
SM
I found a work around ,this is what I did
1) Create a new qvf
2) Use the qvf file that has the data model as a source file in the new qvf ( binary load)
3) Use the following snippet to extract all the tables into an excel file (can't use qvds generated by qvf in qlikview)
binary 'lib://YourPath/YourSource.qvf';
//below code will extract all the tables from the datamodel
for i=0 to nooftables() -1
let vTable =tablename(i);
store '$(vTable)' into path\$(vTable).csv;
Next
Let j=nooftables();
do while j>0
let vTable =Tablename(0);
drop table '$(vTable)';
let j=nooftables();
loop
4) then use the csv's as a source for the qvw
Hi Swarup,
Please install Qlik Sense Desktop application. Its free of cost.
http://us-d.demo.qlik.com/download/
After that, Open your .qvf file into it then follow the below steps:
There is not but you can copy/paste the load script into QlikView :
1. You will probably need to change the FROM <> aspects of your load since Sense uses a different syntax
2. Your colleague will need access to the files / data connections you used.
There will be a one or 2 but the effort should be pretty straightforward. post any errors you encounter attempting this.
The UI is not transferrable however and that is the same going from QlikView to qlik sense or vice versa.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Thank you for the response Rohit.
The post is regarding using binary load using Qliksense as source in Qlikview.
Easiest way would be to export data from Qliksense to excel then use the excel as a source, but that's not the point.The data could run into millions of rows exporting to excel is not feasible.
I have used qlikview (.qvw) as source in Qliksense in the past ,but I'm guessing its not possible to use qliksense i.e .qvf as a source in .qvw.I have tried using .qvf as a source in .qvw file and its throws an error.
Thanks
SM
In Qlikview 11 it is not possible. I do not know about qlikview 12, maybe it is possible in that.
Hi Swarup,
Qlik View is Legacy now and Qlik Sense is future , You can move forward as Qlik view to Qlik Sense but reverse is not possible in my understanding even this doesn't make any sense , Rest Please keep doing R&D and let me know if you will find any solution.
I found a work around ,this is what I did
1) Create a new qvf
2) Use the qvf file that has the data model as a source file in the new qvf ( binary load)
3) Use the following snippet to extract all the tables into an excel file (can't use qvds generated by qvf in qlikview)
binary 'lib://YourPath/YourSource.qvf';
//below code will extract all the tables from the datamodel
for i=0 to nooftables() -1
let vTable =tablename(i);
store '$(vTable)' into path\$(vTable).csv;
Next
Let j=nooftables();
do while j>0
let vTable =Tablename(0);
drop table '$(vTable)';
let j=nooftables();
loop
4) then use the csv's as a source for the qvw