topic Trigger the formula in an input box variable whilst loading in QlikView

Trigger the formula in an input box variable whilst loading

tinkerz1 — Wed, 14 Oct 2015 10:32:05 GMT

Hi,

I have create a variable in QV for entry through the input box

='\\Test1\Test2\Test3\' & Date([Month End Date],'YYYYMM') & 'Data\'

I then want to call it in the load script

But I get the formula not the output

$(var1)

'\\Test1\Test2\Test3\201009\Data\ '

How can I get the formula?

Re: Trigger the formula in an input box variable whilst loading

swuehl — Wed, 14 Oct 2015 10:39:46 GMT

I think you would need a second variable that evaluates the code in the script, like

SET vInput = '\\Test1\Test2\Test3\' & Date(Today(),'YYYYMM') & 'Data\';

LET vEval = $(vInput);

Re: Trigger the formula in an input box variable whilst loading

tinkerz1 — Wed, 14 Oct 2015 11:49:39 GMT

Vinput will be input buy the end user, so the load sript will have to collect it.

Vinput will be an input box so this has not worked for me.

Re: Trigger the formula in an input box variable whilst loading

swuehl — Wed, 14 Oct 2015 12:01:24 GMT

Not sure if I understand what you are trying to tell me.

It doesn't really matter how vInput is created, if it's not evaluating the embedded QV function, I think you need a second variable to evaluate your text. You can create this second variable in the script using LET, potentially also in the variable editor:

=$(=vInput)