topic Re: run qvw from script in QlikView

run qvw from script

Tue, 25 Oct 2011 07:37:44 GMT

hi,

is it possible to call/run/load a qvw file from a script of other model (qvw).

in other words: is it possible that when i load a model to load other model ?

thank you all.

Re: run qvw from script

its_anandrjs — Tue, 25 Oct 2011 07:44:19 GMT

Hi,

Yes it is possible to run any qvw file from any qvw file and also load any qvw file into another qvw file

1. By adding action in the properties like Open Qlikview Document -> Give Document name

2. By doing binary load into another qvw file by adding Qlikview File.

It is your means to ask if so please let me know about that.

Rgds

Anand

run qvw from script

Tue, 25 Oct 2011 07:57:04 GMT

my problem is that in the load of qvw i want to do a load of qvw,

if i anderstand correctly your sulotion works from model by using actions .

run qvw from script

its_anandrjs — Tue, 25 Oct 2011 08:02:07 GMT

Hi,

Ok right when you load any file you incorporate another model also by doing Binary load for this you neet to select -> Qlikview file from where you load a model after selecting Qlikview file a syntax is added on the top of SET statements in the Qlikview file like

Binary Testfile.qvw;

And there is no script of this file available but if you see the Table view you see the model of Testfile.qvw but need to check that there is not so many tables are loaded then model goes unless so wrong in that case.

Let me know.

Rgds

Anand

Re: run qvw from script

Tue, 25 Oct 2011 08:25:00 GMT

maybe i need to mention that i dont want to load the Testfile.qvw each time i load my father qvw file,

i need somthing like :

if (statement = true) then

binary Testfile.qvw ;

endif

run qvw from script

its_anandrjs — Tue, 25 Oct 2011 08:34:50 GMT

Hi,

From my idea i think it is not possible when you load Binary Load

Binary Testfile.qvw;

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Binary Testfile.qvw; syntax would be on top of the SET syntax

without this it will not run and show unknown command thats why binary load not accept the condition.

Rgds

Anand