Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

swarup_malli
Valued Contributor

Binary load using Qliksense as source in Qlikview

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

Tags (1)
1 Solution

Accepted Solutions
swarup_malli
Valued Contributor

Re: Binary load using Qliksense as source in Qlikview

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

5 Replies
Not applicable

Re: Binary load using Qliksense as source in Qlikview

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.

swarup_malli
Valued Contributor

Re: Binary load using Qliksense as source in Qlikview

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

arvind654
Honored Contributor II

Re: Binary load using Qliksense as source in Qlikview

In Qlikview 11 it is not possible. I do not know about qlikview 12, maybe it is possible in that.

Not applicable

Re: Binary load using Qliksense as source in Qlikview

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.

swarup_malli
Valued Contributor

Re: Binary load using Qliksense as source in Qlikview

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