topic Re: need help to write a macro.. in QlikView

need help to write a macro..

sushil353 — Mon, 26 Mar 2012 18:49:33 GMT

Hi All,

I want to write a macro to write an array of values in a list box.

suppose i have an array of values like

a(0)=123

a(1)=124

a(2)=125

a(3)=126

a(4)=127

then using a macro i want to create a listbox and write array values to listbox

Any advise or suggesstions

please help...

thanks

sushi

need help to write a macro..

Mon, 26 Mar 2012 21:03:53 GMT

does it have to be through macro? would doing it in the load script work?

need help to write a macro..

sushil353 — Tue, 27 Mar 2012 05:05:58 GMT

Hi Juan,

I have to use macro. because i am calculating the array using vb script.

Thanks

sushil

need help to write a macro..

Tue, 27 Mar 2012 05:42:16 GMT

The problem is u can only add a field name to a list box, so your data should be in some field (i.e column) then only it can be represenred in a list box...

for example to add field class:

set LB = ActiveDocument.ActiveSheet.CreateListBox

set BoxProp=LB.GetProperties

BoxProp.Def.Name = "Class"

LB.SetProperties BoxProp

to create a field, the script should be modified,

To add a new Line in script we have

rem ** add new line to script **

set docprop = ActiveDocument.GetProperties

docprop.Script = docprop.Script & "Load * from abc.csv;"

ActiveDocument.SetProperties docprop

try to add your array in script, give it a name and then include it in a listbox....

Regards,

Arun Goel

Re: need help to write a macro..

Sat, 07 Apr 2012 12:52:37 GMT

Hi Arun

I am also looking forward to add array to list box created by macros as you discribe it above, but i don't get it.

Help me out to fix this issue. At least how to add values to the list box via macros

need help to write a macro..

Sun, 08 Apr 2012 08:42:04 GMT

Hi Suahil

I am also looking forward to add array to list box created by macros as you discribe it above, but i don't get it.

please Help me out to fix this issue. At least how to add values to the list box via macros