topic Re: Creating and executing dynamic text-file on button click in QlikView

Creating and executing dynamic text-file on button click

Tue, 14 Jan 2014 09:08:42 GMT

Hello community,

I navigate through a document using one ID at a time. This code will give me the according ID:

=only({<Order={'=rank(-Order)=$(vRank)'}>} ID)

I need to create a text-file that has a mainly static structure passing the current ID to the text. Actually this text file has a extension that once clicked, opens up a program with the given search text.

Now ideally the text-file wouldn't need to actually be saved but only created (and removed) when the button was clicked.

Example of how the text might look:

doc_type=ABC

ID=007

Here only the number behind ID= needs to be dynamic.

So this code gives me above text:

='search' & Chr(10) & 'doc_type=ABC' & Chr(10)

&'ID='& only({<Order={'=rank(-Order)=$(vRank)'}>} ID)

But how could I create the file and use it as a variable?

I'm guessing macros are the only way here.

Manually I can get it to work when using the Launch Action and simply paste a valid filepath to the filename property.

Thank you,

Thorsten

Re: Creating and executing dynamic text-file on button click

sujeetsingh — Tue, 14 Jan 2014 09:13:00 GMT

just go for macro and call an action to run Macro

Re: Creating and executing dynamic text-file on button click

Tue, 14 Jan 2014 10:28:00 GMT

I should add that till now I was able to avoid macro coding hence I don't know how to start

Oh, and I need it to work in the browser.

A small sample would help.

Thank you.

Re: Creating and executing dynamic text-file on button click

Wed, 22 Jan 2014 07:23:18 GMT

still looking for a solution here. Anybody?

Re: Creating and executing dynamic text-file on button click

Wed, 22 Jan 2014 08:03:33 GMT

Hi Thorsten,

how do you pass the created text on?

Could you just create two variables - one with the basic text including a second which contains your code giving the ID:

doc_type=ABC

ID=$(varID)

Afterwards you pass the first variable on.

Best regards,

Chris

Re: Creating and executing dynamic text-file on button click

Wed, 22 Jan 2014 14:10:58 GMT

Chris that's what I had in mind - my problem is more the second part: somehow creating the file and then trigger the external program.

Maybe it's possible to write the first variable to a file on disk and execute that path so that the content of the file changes when variable2 also changes. But VB isn't my friend