Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

How to tell QV don't need to reload some of my QVD file ?

Hi All

I have a QV doc , i want to add a command before the QVD file , so that QV will not load those QVD file. and when i want to reload , i just need to remark the line of code , so QV will load the QVD , which is the command ?

Because those QVD are price list , it don't change often.

Paul

1 Solution

Accepted Solutions
vincent_ardiet
Contributor III

Re: How to tell QV don't need to reload some of my QVD file ?

If you don't want to reload your QVD each time, my solution is working.

Partial reload (stop me if I'm wrong), is a mechanism used to load a QVD (your old data) and then to partialy read our datasource (database, xls, csv...) in order to add only new informations.

But, in your case, you don't want to add information to your QVD, you just don't want to reload it.

So, I explain again because I think it wasn't clear enough but a solution is to use 2 applications:

- Create an application PriceList.QVW

- In the script just load your differents price lists:

     load * from $(vQVDPath)BECKHOFF.qvd (qvd);

     Concatenate

     load * from $(vQVDPath)HAKKO.qvd (qvd);

     Concatenate

     load * from $(vQVDPath)MITSUBISHI.qvd (qvd);

- Then switch in you main application

- On the first line of your script use the following instructions:

     Binary PriceList.QVW ;

So, now, you will be abble to reload only our main application, the price list will be always the same without any reload.

And, if you want to refresh your price list, reload PriceList.QVW before reloading your main application.

Regards,

Vincent

13 Replies

Re: How to tell QV don't need to reload some of my QVD file ?

Use Partial reload.

Have a look at Add Or Replace commands which can be used before load statement.

vincent_ardiet
Contributor III

Re: How to tell QV don't need to reload some of my QVD file ?

Hi,

You can create a first application (exemple PRICELIST.QVW) which only loads your price list.

Then your main application will starts (first instruction) with a BINARY calling the PRICELIST.QVW.

So, when you want to reload your price list, you just reload the content of PRICELIST.QVW, then your main application.

Regards,

Vincent


MVP
MVP

Re: How to tell QV don't need to reload some of my QVD file ?

Hi Paul,

Use a conditional in the script, like the following example:

LET vLoadQVDFiles = 0; // change only when you want to reload

IF $(vLoadQVDFiles) = 1 THEN

Data:

LOAD *

FROM PriceData.qvd (qvd);

END IF

// Rest of the script goes here

Hope that helps.

Miguel

gainkarthi
Valued Contributor

Re: How to tell QV don't need to reload some of my QVD file ?

Adding to Miguel's note, you can set up your variable value depends on your condition in Task itself.

rajeshvaswani77
Valued Contributor III

Re: How to tell QV don't need to reload some of my QVD file ?

Further to Miguel's note. You can check if it is 1st of a month or any such criteria and reload only on that day, as your design permits. If the pricelist is an excel file or a physical file you could check the date tiem stamp of teh file to reload it only when it changes.

thanks,

Rajesh Vaswani

Not applicable

Re: How to tell QV don't need to reload some of my QVD file ?

Hi Raj

I try Miguel approach , i manage to set 1 or 0 to control reload QVD.

The minute i stop reload the price data are missing from my QV doc.

what i need is retent or keep the data on QVW file . any idea how to achieve ?

Paul

rajeshvaswani77
Valued Contributor III

Re: How to tell QV don't need to reload some of my QVD file ?

I assume that you are doing  change in teh QVD Loader and not in the dashboard. So the QVD once generated would remain intact. The dashboard would however read all the QVD files. Just that it reads the old file for Price List. Bottomline is you will read all QVD files in the dashboard level however when you read pricelist data source you will create the QVD conditionally. Hope it helps.

Thanks,

Rajesh Vaswani

Re: How to tell QV don't need to reload some of my QVD file ?

Hi,

Yes Miguels Approach says that to not load the Price data.

If you need the data without loading the qvd then you should go with partial reload.

For you case

Have Replace keyword before the load statement for all the tables except PriceData.

And do PartialReload(Ctrl+Shift+R)

Not applicable

Re: How to tell QV don't need to reload some of my QVD file ?

Hi Celam

you understood my issue very well.

Replace

PRICE:

load * from $(vQVDPath)BECKHOFF.qvd (qvd);

Concatenate

load * from $(vQVDPath)HAKKO.qvd (qvd);

Concatenate

load * from $(vQVDPath)MITSUBISHI.qvd (qvd);

But i try the above it does not work. because it still load all the above 3 QVD. i cannot use Add . i think i don't understand what is partial load.

Paul

Community Browser