Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
You could try it: -(filesize(PathFile)>0) as expression within the variable.
- Marcus
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.
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
Thanks!
GetRegistryString() should be helpful!