topic Re: variable in QlikView

variable

syukyo_zhu — Tue, 03 Nov 2015 16:39:14 GMT

Hi,

I want to know if these is way to get value of an variable from another application qlikview, the same way like "binary" for get data from another application.

I can't write my variable in file text because the variable can be changed by user.

Re: variable

swuehl — Tue, 03 Nov 2015 16:44:43 GMT

You can try parsing the values using the XML code that is part of each QVW (you can load the XML code using the wizard), it looks like

<IsConfig>false</IsConfig>

<IsReserved>false</IsReserved>

</VariableDescription>

Re: variable

Oleg_Troyansky — Tue, 03 Nov 2015 16:50:05 GMT

I think you can write a VBScript macro that opens the other document and retrieves the value of the variable from it. The challenge here, besides the trouble of writing a macro like that, is that opening a large document is quite slow.

Then, if you are loading that other document via BINARY already, then you can store your variables in a table and get the table loaded by the BINARY load.

Regarding your last comment - if your other application is running on the server and the users can enter the variable values, then nothing I said would work. Keep in mind that the variable values can be different for different users, so it's not quite easy to fetch the value that you are after...

cheers,

Oleg Troyansky

Check out my new book QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

Re: variable

syukyo_zhu — Wed, 04 Nov 2015 15:26:00 GMT

Hi,

i try your solution,il it work fine.

Then i use function "match" to get only 2 variables which i need for my second application.

Thanks