topic Re: How to create nested queries in QlikView

How to create nested queries

nathroche — Tue, 16 Feb 2016 10:24:54 GMT

Hello,

I am looking to create a script that would allow me to use variables from another script.

For example:

from a variable [IPP] a first request "R1", I'd use it again in a second request "R2"

[R1]. [IPP] etc ...

If you have an idea of how to proceed.

Thank you!

Nathalie

Re: How to create nested queries

marcus_sommer — Tue, 16 Feb 2016 11:42:28 GMT

It's not really clear what do you want to do but I think this will be helpful for you:

Loops in the Script

The Magic of Variables

- Marcus

Re: How to create nested queries

Mark_Little — Tue, 16 Feb 2016 11:50:12 GMT

Hi,

Some more information would be helpful.

If i understand correctly the way i would approach it is to keep my variable or variables in an external file.

This way you run your first script which can then write your variable value to the file, then second script can load the value into a variable and used in the load, this can be repeated any number of times.

You will just have to consider you reload schedule to make sure this is loaded and set correctly.

Mark

Re: How to create nested queries

Colin-Albert — Tue, 16 Feb 2016 12:10:38 GMT

You could use include files to share common code between applications.

The $(Include) which you $(Must_Include) into your toolkit

Re: How to create nested queries

nathroche — Tue, 16 Feb 2016 15:59:03 GMT

Thank you for your reply, I look to my side and I tell you.

Nathalie

- - - -

Merci pour votre réponse, je regarde de mon côté et je vous dis.

Nathalie

Note: Edited by Community Moderator to include English translation as a courtesy.