topic Re: variables to parameters of Button with external program in QlikView

variables to parameters of Button with external program

chrweber — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

i have a button with an external program (powershell).

I wish to pass a variable value as paramater.

How do I evaluate variables within the parameter section of the external program dialog.

Best regards

Re: variables to parameters of Button with external program

Anil_Babu_Samineni — Tue, 28 Nov 2017 10:51:39 GMT

Does that powershell accessable to Qlik? If so, we can work

Qlikview Parameterised Variables

Variables with Parameters

Re: variables to parameters of Button with external program

chrweber — Tue, 28 Nov 2017 10:58:19 GMT

Unfortunately, that is not my problem, or maybe I was not clear

I have a button, calling an external program

The Dialog allows the selection of a program and I can provide an arbitrary parameter string.

Within that parameter string I wish to evaluate a formula (or dereference a variable)

How can I do that.

Re: variables to parameters of Button with external program

Anil_Babu_Samineni — Tue, 28 Nov 2017 11:12:36 GMT

You can, Can you share exactly your intend of current expression which you have so then i may work for you

Re: variables to parameters of Button with external program

chrweber — Tue, 28 Nov 2017 11:17:54 GMT

Of course (I am translating to english, so I am guessing the proper labels):

Action:

Execute

Application: Powershell.exe

Parameter: -NonInteractive -ExecutionPolicy Bypass <myVariable or Function value>

I hope that clarifies it. How can I escape/dereference here

Re: variables to parameters of Button with external program

Anil_Babu_Samineni — Tue, 28 Nov 2017 11:31:08 GMT

That means you have one batch file which extension called .exe and you are going to use that into using button. That means you are going to call from that .exe file there are multiple variables stored. So, You want to use that parameter variable call into Qlik. Is this you are trying to explanation?

Re: variables to parameters of Button with external program

chrweber — Tue, 28 Nov 2017 11:50:30 GMT

Maybe the GUI command is "Run" rather than "Execute"

And "Powershell.exe" is basically the new "cmd.exe"

And I want to call the executable from within Qlikview and hand it qlik variables as parameters.

Re: variables to parameters of Button with external program

chrweber — Tue, 28 Nov 2017 12:05:11 GMT

I want to insert qlik-variables into the parameters of "Launch"

Re: variables to parameters of Button with external program

chrweber — Tue, 28 Nov 2017 12:24:07 GMT

It appears that i have to concat the parameter string using & and ' (apostrophe)

The parameter string should be as follows:

='<parameter text>' & <qlik variable or function> & '<parameter text>' & ...

Re: variables to parameters of Button with external program

Anil_Babu_Samineni — Wed, 29 Nov 2017 01:50:10 GMT

Don't have idea, May be marcus_sommer‌ petter-s‌ help you