Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm slogging around mostly not answered or half-related posts looking for a way to make the Clear All button itself clear variable input boxes and not just the list boxes. Because Qlikview Management Console on the Qlikview server doesn't let us schedule automated reloads on qlikviews containing Macros, I need an angle to add something to the list of default Document Event Triggers listed under Settings->Document Properties: Triggers..
The default document event triggers are the four items:
OnAnySelect
OnOpen
OnPostReduceData
OnReload
I want Document Event Trigger that says OnClearAll that then lets me Add Action->External->Set Variable and maybe write a bunch of these actions to have it set each variable to blank (or '' or Null()).
If I must, I'll go with a textbox button or maybe check with people whether OnOpen or some other document/sheet event like that would be good to clear the variables. Really hoping I can get the Clear All button we already have to Clear All though. Making a clear variables button feels eerily like making a virtual backspace key...
I just created your concept in its own standalone workspace and it worked just fine! For some reason it won't integrate into my existing workspace. The QVW is extremely large so it's not something I can upload, unfortunately. It's a shame, because your concept is exactly what I need, but I can't figure out why it will not work.
If the Clear field is in its own table not connected to the rest of the data model, then I can't think of anything else.
Hello stigchel, this solution would work also on date rages created using calendar objects (based on vStartDate and vEndDate)?
thank you!
Raluca