5 Replies Latest reply: Nov 3, 2016 12:05 PM by swarup malli RSS

    Binary load using Qliksense as source in Qlikview

    swarup malli

      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

        • Re: Binary load using Qliksense as source in Qlikview
          Rohit Kumar

          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

            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