topic Re: set variable in QlikView

set variable

warrentk80 — Thu, 14 Nov 2013 10:00:39 GMT

Hello everyone, I need to store the value of a variable in a text file to read then later to do the analysis on the basis that the information Employment varibile (set via input box and / or button)

Show me someone would know how to store the value of a variable?

thanks

Andrea

Re: set variable

Thu, 14 Nov 2013 10:10:11 GMT

try this

store $(variablename) into D:\test.txt;

Re: set variable

kaushiknsolanki — Thu, 14 Nov 2013 10:13:11 GMT

Hi,

Have a look at the below link.

http://community.qlik.com/thread/57133

http://www.qlikfix.com/2013/09/06/importing-and-exporting-variables/

Regards,

Kaushik Solanki

Re: set variable

warrentk80 — Thu, 14 Nov 2013 10:27:50 GMT

good morning

Thank you for your kind and quick response.

where to launch through the store command button $ (variablename) into 😧 \ test.txt? the store is a command script how do I run it from the front end?

thanks

Andrea

Re: set variable

senpradip007 — Thu, 14 Nov 2013 10:35:48 GMT

try this

store $(VariableName) into <dir_path>\Store.txt

Here Dir_path is the pathname where you want to store the file.

Re: set variable

warrentk80 — Thu, 14 Nov 2013 10:38:08 GMT

good morning

Thank you for your kind and quick response.

but where execute this comand?

Re: set variable

Thu, 14 Nov 2013 10:46:12 GMT

try this

in script side write this code.

Let var1=5;

Store $(var1) into D:\test.txt;

Re: set variable

warrentk80 — Thu, 14 Nov 2013 10:55:58 GMT

how do I run the script code from the button?

Re: set variable

Thu, 14 Nov 2013 13:21:51 GMT

Hi Andrea,

I guess, you want to store the Variable value from the UI/Front end only, as per my knowledge we can not store anything to a file (text/excel etc) from UI. If you are looking for write back capability, then you will have to write a macro which will actually store the variable value to a text file.

Create a list box and use expression to get variable value and use below macro. Keep Requested Module Security as System Access and Current Local Security as Allow System Access. Create a button and trigger this macro.

sub test

set lb = ActiveDocument.GetSheetObject("LB01")

lb.Export "D:\Amey\Training\test.txt" , ";"

end sub

Hope this helps!

Thanks,

Amey