topic Re: Binary load using Qliksense as source in Qlikview in App Development

Binary load using Qliksense as source in Qlikview

swarup_malli — Mon, 12 Sep 2016 19:45:44 GMT

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

Re: Binary load using Qliksense as source in Qlikview

Tue, 13 Sep 2016 11:35:21 GMT

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.

Re: Binary load using Qliksense as source in Qlikview

swarup_malli — Wed, 14 Sep 2016 19:16:26 GMT

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

Re: Binary load using Qliksense as source in Qlikview

MK9885 — Wed, 14 Sep 2016 19:23:25 GMT

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

Re: Binary load using Qliksense as source in Qlikview

Thu, 15 Sep 2016 04:33:22 GMT

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.

Re: Binary load using Qliksense as source in Qlikview

swarup_malli — Thu, 03 Nov 2016 15:05:19 GMT

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;

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