Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Interesting Qlikview problem - Pass Load script to second QVW

Hi,

Background:

We have few users who writes the load script in QVWs and reloads them.

We are trying to build  some automated process for them. So there is other logic need to run along with the load script that user writes.

Issue:

To achieve the above scenario, I would need to pass the load script that user written from one QVW to another QVW and reload it.

I initially thought of taking the load script as variable and pass it to next QVW.

But not quite sure how do we implement this as it shouldn't effect the User ability to write the load script .

Is it possible to make a part of load script as a variable or a sub routine to pass as an argument to other qvw and reload?

Thanks.

6 Replies
Creator II
Creator II

Re: Interesting Qlikview problem - Pass Load script to second QVW

Use the include statement.

Have your users create a script and save it as a text file ex: script.txt

then in an appropriate location in your load script:

$(Include =filename )

Highlighted
Creator II
Creator II

Re: Interesting Qlikview problem - Pass Load script to second QVW

Disclaimer: That is potentially risky and may be unpredictable with variables, etc.

Highlighted
Not applicable

Re: Interesting Qlikview problem - Pass Load script to second QVW

Hi Steve,

Thanks for replying.

Users are not willing to use text or QVS files as they can't see the Qlikview language while writing the load scripts.

They want to write the load script in QVW itself.

Any ideas?

Is it possible to store a subroutine or pass the subroutine to another QVW?

If so, I can ask them to write their script within a subroutine.

Highlighted
Creator II
Creator II

Re: Interesting Qlikview problem - Pass Load script to second QVW

Then I think a Binary Load is your best bet.

Have the users create a QVW (QV1.qvw) for example.

The FIRST line of the next QVW is just :

Binary [path]\QV1.qvw;

Where path is your path to the qvw.

From there you can add to it.

Highlighted
Not applicable

Re: Interesting Qlikview problem - Pass Load script to second QVW

I have some thing else to binary load in the second qvw.

So this option doesn't work

Highlighted
Creator II
Creator II

Re: Interesting Qlikview problem - Pass Load script to second QVW

Can the content of the first QVW be stored to QVDs and subsequently loaded into the second QVW?

If not, I think you may be out of options given your previous restrictions. I look forward to seeing what others may post.