topic Re: How to create a single .qvd file from .qvw (Data model) with using binary load and pass the parameters in QlikView

How to create a single .qvd file from .qvw (Data model) with using binary load and pass the parameters

shaikbakshu — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am new to Qlikview , I have a requirement to create complete Qlikview data model into one single .QVD file.

For example,

I have one "sample.qvw" file in this file we have data model like Star schema or snow flake schema,

I will create one more "Sample2.qvw" file , in this Sample2.qvw file I was imported to "Sample.qvw" file by using Binary Load.

I am facing an error, when I pass the variables to Binary load for access sample.qvw file into sample2.qvw then it is not created single qvd file

PFB,

Binary [$(vQVWDir)\$(vQVWfile).qvw];

from the above vQVWDir means .QVW files directory and vQVWfile means .QVW file name.

Could you any one please help me to create Data model to one single .qvd file by using variable for dynamic selections

Regards,

Bakshu

Re: How to create a single .qvd file from .qvw (Data model) with using binary load and pass the parameters

marcus_sommer — Thu, 21 Jun 2018 15:23:55 GMT

A qvd is designed to keep a table and not a datamodel. There are not many use-cases where it might be sensible to ignore this fact especially not as a "standard" approach or by quite complex datamodels or large datasets. But of course you could do it: Storing a Data Model in a Single QVD | Qlikview Cookbook.

- Marcus

Re: How to create a single .qvd file from .qvw (Data model) with using binary load and pass the parameters

shaikbakshu — Fri, 22 Jun 2018 13:01:35 GMT

Hi Marcus,

Thank you for your response ,

I was use script/.qvc file from the exclude options in my script to create data model into one single .qvd.

When i was run that script then create single qvd file based on that script.

Now i am facing issues is when i was use Binary load with variables then single .qvd file was not created,

but sample.qvw file was reloaded.

Bellow is my Bat file for run QVW file.

@echo off

"C:\Program Files\QlikView\Qv.exe" /r "/vQVWDir=%~1" "/vQVWfile=%~2" "%~1\%~2.qvw"

can you please suggest me to how to resolve it.

Regards,

Bakshu.

Re: How to create a single .qvd file from .qvw (Data model) with using binary load and pass the parameters

marcus_sommer — Sun, 24 Jun 2018 16:38:51 GMT

I'm not absolutely sure but I think it couldn't work in this way because a binary load must be the very first statement within a load and your assigning of values to variables will probably happens before the load-statement is executed and therefore the binary load failed.

- Marcus

Re: How to create a single .qvd file from .qvw (Data model) with using binary load and pass the parameters

sujan24s — Mon, 25 Jun 2018 05:18:42 GMT

Hi,

May be this will Help you

BINARY load with dynamic file name