Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
akpofureenughwu
Contributor 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
Honored Contributor

Re: Binary Loading Implementation

akpofureenughwu
Contributor III

Re: Binary Loading Implementation

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

Regards

How do one use the binary function on Qliksense?

Re: Binary Loading Implementation

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
Contributor III

Re: Binary Loading Implementation

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

Re: Binary Loading Implementation

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
Contributor III

Re: Binary Loading Implementation

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

Re: Binary Loading Implementation

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
Esteemed Contributor II

Re: Binary Loading Implementation

Not applicable

Re: Binary Loading Implementation

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