topic Re: Create an Input Box (VBA) for Variables in QlikView

Create an Input Box (VBA) for Variables

rustyfishbones — Fri, 28 Feb 2014 16:10:25 GMT

Hi All,

I have 10 variables, where I want the user to change the value in these variables based on certain criteria.

I could just have something like this where the user could just change it.But I find it awkward to add the qty

I would like to have an input box something like the image below, and that would populate the variable

Anonymous — Fri, 28 Feb 2014 16:14:18 GMT

Alan,

I'm probably missing something - but why don't you use the regular QV input box object?

Regards,

Michael

chiru_thota — Fri, 28 Feb 2014 16:23:36 GMT

Hi,

you can use QV inputbox object as Michael mentioned.

You can define variables and link them to input boxes

rustyfishbones — Fri, 28 Feb 2014 16:27:07 GMT

I don't like it, it can be quite cumbersome

Anyway, I think I have a solution I got from the API guide

here it is, I have a variable called input.picking.ops

And I added this to the Edit Module

SUB inputpickingops

oldtext = ActiveDocument.Evaluate("input.picking.ops")

t = ActiveDocument.GetApplication.InputBoxEx("Enter New Variable Value for input.picking.ops :",oldtext)

ActiveDocument.Variables("input.picking.ops").SetContent t,true

END SUB

With this result