Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a document with some input fields. These input fields are reset to zero using a macro. The macro code is shown below.
When I reduce this document from within QlikView it continues to work. When the document reloads using the QlikView Management Console it works. The macro does not work after being reduced by the QlikView Management Console. If I open this reduced document in the desktop program the button to launch the macro opens the Edit Module screen as if there was a problem with the macro, but the code has no problems.
So far my search has not turned up any related results. I did find a bunch of information about macros not working on a PostReload trigger, but that is not the case here since the macros are only fired by buttons.
Has anyone else run into this? I'm guessing there is a setting somewhere I need to enable.
Thanks!
My code from the Edit Module screen:
Sub ResetGoalIGS
set fld = ActiveDocument.Fields("Goals.YTDIGS")
fld.ResetInputFieldValues 0
set fld = ActiveDocument.Fields("Goals.CYIGS")
fld.ResetInputFieldValues 0
end sub
Sub ResetPlacementIGS
set fld = ActiveDocument.Fields("Placements.IGS")
fld.ResetInputFieldValues 0
end sub
Some more information about this: It looks like after a reduce my inputfields have been converted to non-input fields which is causing the macro to fail. It also causes my InputSum expressions to fail and display null. What causes a reduce and/or distribute to change an inputfield to a non-inputfield?