Binary Loading Implementation

[akpofureenughwu]

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

[stabben23]

Hi,

maybe rwunderlich‌ have solve Your problem?

Storing a Data Model in a Single QVD | Qlikview Cookbook

[akpofureenughwu]

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

Regards

How do one use the binary function on Qliksense?

[Anonymous]

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]

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]

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]

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

[Anonymous]

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]

here's a Guide how-to

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

[#10]

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 = ;