topic Re: Macro to read text file and set variable externally in QlikView

Macro to read text file and set variable externally

Shivam_Sahu — Sat, 16 Nov 2024 04:43:21 GMT

Hi All

I want macro to read text file inside which I have created a variable say

SET vQVW ="myqlikviewvariablevalue"

I want to use this variable when I open my application.

Can any share macro for this purpose.

Re: Macro to read text file and set variable externally

m_woolf — Fri, 18 Jan 2019 13:12:04 GMT

No need for a macro. Read the text file in your load script. If you search the forum for "read variables from text file", you will find many examples. Here's one: https://community.qlik.com/t5/QlikView-App-Development/set-variable-from-text-file/m-p/321019

Re: Macro to read text file and set variable externally

Shivam_Sahu — Fri, 18 Jan 2019 17:41:52 GMT

Mwoolf,
I know this way but,
I dont want to load application ,My requirements is like that when I open a Qv application variable value should have been set.

Re: Macro to read text file and set variable externally

Shivam_Sahu — Fri, 18 Jan 2019 18:42:19 GMT

Can anyone share their idea for this?
I think macro will do the job with on open trigger.

Re: Macro to read text file and set variable externally

m_woolf — Fri, 18 Jan 2019 19:59:12 GMT

Try this:

Re: Macro to read text file and set variable externally

jerrysvensson — Mon, 21 Jan 2019 09:47:31 GMT

Is this suppose to happen when published?
In that case you have to use plugin, Ajax (WebView) doesn't have local file access.

Re: Macro to read text file and set variable externally

Shivam_Sahu — Mon, 21 Jan 2019 09:53:34 GMT

Thanks @m_woolf ,

This Macro is working as I wanted.