Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
andreyfcdk91
Creator
Creator

Updating variable in the external trigger

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.

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

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

View solution in original post

4 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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

- Marcus

andreyfcdk91
Creator
Creator
Author

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.

marcus_sommer
MVP & Luminary
MVP & Luminary

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

View solution in original post

andreyfcdk91
Creator
Creator
Author

Thanks!

GetRegistryString() should be helpful!