topic Using an Input Box for Script in App Development

Using an Input Box for Script

Frédéricdh — Mon, 18 Mar 2024 14:25:47 GMT

Hello,

I'm using an InputBox to use the variable in the script, but the variable in the Input Box is defined with an function expression as 'Num(GetFieldSelections(X))' and then in the script Qlik use the text of the function and not the value of the function.

What must I do, to have only a value

Re: Using an Input Box for Script

F_B — Mon, 18 Mar 2024 15:18:08 GMT

Did you use a LET statement?

Working with variables in the data load editor | Qlik Sense on Windows Help

Re: Using an Input Box for Script

Frédéricdh — Tue, 19 Mar 2024 12:42:32 GMT

Yes I use Let but I doesn't work

Re: Using an Input Box for Script

vuan — Tue, 19 Mar 2024 12:49:23 GMT

Do you still have the let in your script? Be sure to remove this line from your script.

Re: Using an Input Box for Script

marcus_sommer — Tue, 19 Mar 2024 13:58:29 GMT

You need any logic which stored the evaluated result as a fix value - maybe with any macro which assigned the value to another variable or which exports it in a text-file or Excel.

Re: Using an Input Box for Script

Frédéricdh — Tue, 19 Mar 2024 14:05:46 GMT

Hello, can you give me a link: how to create a macro and how to export in a text file?

thank you

Re: Using an Input Box for Script

marcus_sommer — Tue, 19 Mar 2024 15:48:39 GMT

You may use a table-chart without any dimension and just your variable-calculation as expression and then a statement like:

sub x
set obj = ActiveDocument.GetSheetObject("CH21")
obj.ExportEx "D:\test.txt", 1
end sub

to export it as txt or by using 5 or 6 as parameter as xls/xlsx.

A good source for such stuff is the APIGuide.qvw within your QV install-folder (by automation).

Re: Using an Input Box for Script

PhanThanhSon — Tue, 19 Mar 2024 15:51:31 GMT

Hi,

I believe if you have a variable vTest = Num(GetFieldSelections(X)), you either need an equals sign at the beginning of your expression or you have to handle your call like this: $(=vTest).

Best regards Son

Re: Using an Input Box for Script

Frédéricdh — Thu, 21 Mar 2024 07:23:15 GMT

Hello PhanThanhSon,

no your solution doesn't work, I have a variable like vTest = GetFieldSelections and in the script I use $(=vTest), but when I load the script, Qlik doesn't find a value for the variable.

I find a solution for that and I need to use a Button and define a set variable with this button.

Best Regards

Frédéric S.

Re: Using an Input Box for Script

marcus_sommer — Thu, 21 Mar 2024 07:38:52 GMT

You will always need an external storing because the variables calculation-result exists only within the UI. As far as the reload is performed the UI is gone and it exists only the scripted parts which is by the variable just the value respectively the calculation-string.

Re: Using an Input Box for Script

Frédéricdh — Thu, 21 Mar 2024 10:23:43 GMT

What is a UI?

Re: Using an Input Box for Script

marcus_sommer — Thu, 21 Mar 2024 13:20:28 GMT

Meant is the user-interface respectively the surface on which all your sheets and objects are. As far as a reload is triggered the UI is removed as well as the underlying data-model and the data. Only script-parts and information which sheets/objects with which properties exists are persisting and are rebuild against the updated data-model if the reload has finished.

Re: Using an Input Box for Script

Frédéricdh — Fri, 22 Mar 2024 06:20:51 GMT

Sorry, I don't understand the part with "Only script-parts and information which sheets/objects with which properties exists are persisting"

Re: Using an Input Box for Script

Frédéricdh — Fri, 22 Mar 2024 06:49:43 GMT

Hello Marcus,

I found a solution in the name of a Button and then I make two actions a Set Variable and a Reload.

And in the script, I wrote this var = $(vvar) and it works

Does that illustrate your comment?

Re: Using an Input Box for Script

marcus_sommer — Fri, 22 Mar 2024 07:10:17 GMT

It means by a reload all data and with it the data-model are dropped and with it also the possibility to access any calculated results against the data as well as accessing any sheets or objects.

You could comprehend it by opening an application per start-window without data and then storing the application in this state. Then go per file-explorer to the application and you will see that the file has just a few KB (mainly caused by the xml-overhead - the real information is much smaller) and opening the file per editor. That are the available information for the application if a reload is started.

Re: Using an Input Box for Script

marcus_sommer — Fri, 22 Mar 2024 07:23:27 GMT

Yes, of course that's a simple way to write a fixed value into the application-properties and should be working as far as you could perform the reload directly afterwards or if the application could be saved with it.

I didn't thought on it because I don't use such things in an active way else only automated and all needed information will be written/exported in any kind of files.

Re: Using an Input Box for Script

AT_7 — Thu, 16 May 2024 13:16:09 GMT

Did you fine solution for this. I am working on something similar but donno how to fix

Re: Using an Input Box for Script

Frédéricdh — Tue, 21 May 2024 07:29:41 GMT

Yes it works 🙂

Re: Using an Input Box for Script

AT_7 — Tue, 21 May 2024 11:56:40 GMT

please share

Re: Using an Input Box for Script

Frédéricdh — Tue, 21 May 2024 12:03:28 GMT

we can make a visioconference and I show you