topic Updating variable in the external trigger in QlikView

Updating variable in the external trigger

Anonymous — Wed, 11 Jul 2018 16:55:13 GMT

Hi experts!

I would like to ask you, if it's possible in qlikview to update variable value depending on external event?

For example, in the simple attachment i have test variable, which should be equal to 1 if there's a txt file in the same folder, if not = 0.

This should be updated in online mode without additional reload.

Is that possible to create some external event trigger?

Thanks.

Re: Updating variable in the external trigger

marcus_sommer — Thu, 12 Jul 2018 11:16:24 GMT

You could try it: -(filesize(PathFile)>0) as expression within the variable.

- Marcus

Re: Updating variable in the external trigger

Anonymous — Thu, 12 Jul 2018 11:22:39 GMT

Thanks.

As far as i know, filesize is a script function. May i be wrong?

I need dynamic reaction in front-end if file exists or not.

Re: Updating variable in the external trigger

marcus_sommer — Thu, 12 Jul 2018 11:37:31 GMT

Yes, you are right - filesize() isn't available from the UI.

Maybe QlikView Direct Discovery on the txt could be an alternatively and the expression within the variable counts anything from the file or checked the exists of any field or something similar.

Another way might be to implement a batch triggered (each n seconds/minutes) from the windows task which checked the file and writes the result anywhere in the registry - and the Qlik variable contained: GetRegistryString().

- Marcus

Re: Updating variable in the external trigger

Anonymous — Thu, 12 Jul 2018 12:53:51 GMT

Thanks!

GetRegistryString() should be helpful!