topic Re: Change the Generator - with a command "call from QVD? in QlikView

Change the Generator - with a command "call from QVD?

Fri, 20 Mar 2015 09:09:52 GMT

I want to change the struktur of the "Generator" - Where should I do this? In the Scrpt of the Qlickview Generator or in the qvd or in the QVS Scripts?

my Problem:

In the Generator I change the Script "main", "Version a. ChangeLog",..., "loadFromDB".

By the QVS script I have the Expression:

sub loadQVD (name1)

$(name1):

Load * from (name1).qvd (qvd);

I have also the QVS, but I get the error_

"Tabelle not found". But I have this QVD, a blank data.

Where should I change this? Must I change the QVS?

Re: Change the Generator - with a command "call from QVD?

Peter_Cammaert — Fri, 20 Mar 2015 09:20:21 GMT

You have two choices. Either one will do. The first one is less flexible (all QVDs should reside in the same folder), the second one means more work.

Prefix the source specification with a correct path (or a variable that contains the path to your QVDs), like in:
LOAD * FROM D:\Data\$(name).qvd (qvd);
Or in every call to the loadQVD subroutine, add this same path to the parameter value, like in:
CALL loadQVD('D:\Data\DateiEins.qvd');

Best,

Peter

Re: Change the Generator - with a command "call from QVD?

Fri, 20 Mar 2015 09:52:23 GMT

The Generator take the correct "qvd". I test it with the debugger, "STORE name1 INTO 'K:\Elger\new\qvshare\daten\qvd\abas\new\help1.qvd (qvd)

I make it with "LET base = 'K:\Elger\new\qvshare'; and in the script "LET Dir_data = base & '\data\qvd';

He found it but he send despite the error!

Re: Change the Generator - with a command "call from QVD?

Fri, 20 Mar 2015 10:07:22 GMT

@Peter Cammaert thanks for answer, despite I have been having the same problem.

And on the next step:

"Tabelle not found!"

And on the right side of the debugger i see now:

"ScriptErrorCount 1

ScriptErrorDetails "Tabelle nicht gefunden"

ScriptErrorList General Error

ScriptError General Error"

Re: Change the Generator - with a command "call from QVD?

Peter_Cammaert — Fri, 20 Mar 2015 10:18:06 GMT

My best suggestion to you is: let the Generator create a log file (enable Settings->Document Properties->General->Generate log file). In the log file, all variables will be expanded so that you can see which path and file name are being used in reality.

BTW you store table name1 into file help1. Which table name do you specificy as parameter to the loadQVD call?

Re: Change the Generator - with a command "call from QVD?

Fri, 20 Mar 2015 10:30:50 GMT

And in the QVD I have nothing to change? Only in the Script in the Generator?

Re: Change the Generator - with a command "call from QVD?

Peter_Cammaert — Fri, 20 Mar 2015 11:21:15 GMT

A single QVD contains a single table with rows and columns. QVDs can only be changed by changing the corresponding script code.

If you mean, "do I have to change the QVW" (report document), you may have to. If the location of the generated QVDs changes in the Generator, then you better modify the LOAD statements used by the QVW as well. If the QVW uses the same external script file (where SUB loadQVD resides), that you already corrected, then you are set and ready to go.

Re: Change the Generator - with a command "call from QVD?

Fri, 20 Mar 2015 11:29:23 GMT

Thank You! I will make it! That was very helpful from you.