Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
akpofureenughwu
Creator III
Creator III

Binary Loading Implementation

My firm usually receive qvd from a data firm to design our dashboard but that's no more

There is a qvw file I have and I need to convert it to qvd?

How do I do it? especially on a qliksense application

I placed a sample file for easy illustrATION.

Regards

10 Replies
stabben23
Partner - Master
Partner - Master

akpofureenughwu
Creator III
Creator III
Author

Thanks Johannson for your response but that's not I want to achieve.

Regards

How do one use the binary function on Qliksense?

Anonymous
Not applicable

The QlikSense Help descibes Binary Load and gives examples, https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Scripting/ScriptRegularStatements/Binar...

Note:  The Binary command needs to be the first line of the load script.

akpofureenughwu
Creator III
Creator III
Author

Thank you Bill.. The link was helpful but I still can't extract the date in the existing qvw into a qvd

I still open to suggestions. Thank you all

Anonymous
Not applicable

Maybe you could write a new qvf /qvw that:

  • Loads the source qvw data using a Binary load
  • This will produce a data model containing all the tables
  • Then in the new load script add Store commands to store these tables into QVD's

I have had a quick look at your qvw and it only has one table so should be quick to script.

akpofureenughwu
Creator III
Creator III
Author

Exactly my friend but I don't know how to write the script..

Anonymous
Not applicable

This script line Binary loads your qvw and has to be the first line in your script.  You will need to create a suitable //lib Data Connection :

    Binary [lib://Binary/SOLMAN_CHARM_ITQA.qvw] ;

This stores the resident table into a qvd :

     Store [TEMP1-1] into [lib://Binary/TEMP1-1.qvd] (qvd) ;

vinieme12
Champion III
Champion III

here's a Guide how-to

Qlik Sense Desktop - Loading Data from QlikView Applications (video)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable

After Binary load use below piece of code to convert all tables in data model into QVD.

For i=0 to NoOfTables()-1

     LET vTableName = TableName(i);

     STORE $(vTableName) Into [\\qvdpath\$(vTableName).qvd] (qvd);

     DROP Table $(vTableName);

     LET vTableName = ;

NEXT i

SET i = ;