topic MACRO Array in QlikView

MACRO Array

Tue, 22 Sep 2009 15:48:50 GMT

Hello everyone!

I wanted to know how to dynamically load an array via a macro.

CIAO!

Daniela

MACRO Array

Wed, 23 Sep 2009 11:30:54 GMT

you can simulate an array by loading to a table and using functions like fieldvalue.

MACRO Array

Wed, 23 Sep 2009 14:04:06 GMT

But this is not dynamic array but static!
I need dynamic!

Daniela

MACRO Array

Wed, 23 Sep 2009 16:12:29 GMT

Can you give an example of how you intend to use this array?

MACRO Array

Wed, 23 Sep 2009 17:21:01 GMT

Excuse my English .......... maybe I can not explain!

I want to dynamically load the list of objects in an array.

This is an array

bildArr = Array("CH112", "CH113", "CH123", "CH115", "CH144", "CH124", "CH125", "CH126", "CH127")

I want to make a macro that loads at runtime

Daniela [:'(]

MACRO Array

Wed, 23 Sep 2009 17:43:58 GMT

Try using this in your macro...

Objects = ActiveDocument.ActiveSheet.GetSheetObjects
For i = lBound(Objects) To uBound(Objects)

.... do something ....

MACRO Array

Wed, 23 Sep 2009 19:07:40 GMT

OK!
But with that education is the loading of the array???

Daniela[:'(]

MACRO Array

Wed, 23 Sep 2009 19:50:31 GMT


Daniela wrote:
But this is not dynamic array but static!
I need dynamic! 
Daniela<div></div>

sorry...I got confused with the "dynamically load an array" part.

a couple of questions: what values do you want to load in your array and when will you be reloading/resizing it?

MACRO Array

Wed, 23 Sep 2009 20:01:09 GMT

Quote: "But with that education is the loading of the array???"

Sorry, this lost something in the translation.

The 'Objects' in the code that I posted above is the array, and this gets loaded when the macro runs. You can set macros to run on various events (such as opening the document) or to run from a button. It will be dynamic in the sense that it will be recreated when the macro runs - it will hold all objects on the active sheet (as I have quoted it), and if you add another object that will be included next time the macro runs.

Perhaps you could create a QlikView document and load it to the Forum. If you point out what works and what you still need to do, there are people that can 'fix' it and post back the answer.