topic How to define chartArray with variable? in QlikView

How to define chartArray with variable?

Andrius45 — Thu, 15 Dec 2016 15:07:51 GMT

Hey guy,

I am trying to modify Macro for exporting certain tables to Excell. The only problem is that right now those tables are hard coded into macro and I need to change that to variable. Any help would be much appreciated.

Right now part of my code looks like this:

chartArray = Array("CH944", "CH893", "CH863", "CH878")

Array("CH01", "CH02"))

usedRows=0

For Each chart In chartArray

Set l = ActiveDocument.GetSheetObject(chart)

chartCaption = l.GetCaption.Name.v

I would like to switch this part Array("CH944", "CH893", "CH863", "CH878") with a variable, any ideas on how can I accoplish that??

Re: How to define chartArray with variable?

tamilarasu — Thu, 15 Dec 2016 17:07:46 GMT

Hi Andrius,

Have a look at the attached file.

Sub Test

vArray = ActiveDocument.GetVariable("vChart").GetContent.String
chartArray =split(vArray, ",")
  
For each chart in chartArray
Set l = ActiveDocument.GetSheetObject(Chart)
chartCaption = l.GetCaption.Name.v
Msgbox chartCaption
Next
      
End Sub

Let us know.

Re: How to define chartArray with variable?

Andrius45 — Fri, 16 Dec 2016 09:36:44 GMT

Thanks alot Tamil, it worked!

Re: How to define chartArray with variable?

tamilarasu — Sat, 17 Dec 2016 07:13:43 GMT

No problem Andrius. Happy weekend .