Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Functionality Lost

I have a model where I have "What If" analysis built into it.  I use the following variables defined as:

INPUTFIELD vPCT;
INPUTFIELD vDollars
;

After I publish the model it works fine on the entire model, but when I distribute it by Office I loose the ability to enter data and do the what-if calculation.  I run the following macro to initialize the input fields.

sub updateRatePct

set fld = ActiveDocument.Fields("vPCT")

fld.ResetInputFieldValues 0

set fld = ActiveDocument.Fields("vDollars")

fld.ResetInputFieldValues 0

end sub

Thanks

0 Replies