topic How to read Multibox object value in macro? in QlikView

How to read Multibox object value in macro?

Mon, 07 May 2012 08:12:50 GMT

Hi,

I need to export few pivot tables to excel and I am using macro for the same. These pivot tables are getting dynamically displayed on the basis of value of a Multibox. I need to add condition of the values of multibox in excel macro. I am able to read variables but not objects. Please help!!

Thanks,

Kirti

How to read Multibox object value in macro?

m_woolf — Mon, 07 May 2012 11:01:21 GMT

The multibox displays the selections for a field (or fields).

Look in the APIGuide for code to cycle through the selections in a field.

How to read Multibox object value in macro?

Mon, 07 May 2012 11:14:09 GMT

Hi,

Thanks for response.

But I am new to Qlikview, can you please confirm where can I find this guide??

Regards,

Kirti

How to read Multibox object value in macro?

m_woolf — Mon, 07 May 2012 11:18:59 GMT

You should have a QlikView folder under My Documents. There should be a documentation folder there.

How to read Multibox object value in macro?

Mon, 07 May 2012 14:50:59 GMT

I have found the API QVW file but this is very complex to understand so quickly. And I need to know thes olution very urgently.

Can somebody please tell me how can I read multibox value in macro code. For now I am using,

set v = ActiveDocument.GetSheetObjects("MB01").GetRelevantSelections

if v.GetContent.String = Allowed then

--stmts

end if

But this is giving error which says, object required.

Thanks,

Kirti

How to read Multibox object value in macro?

m_woolf — Mon, 07 May 2012 17:52:38 GMT

This code from the APIGuide, will display the currently selected items in a field:

set val=ActiveDocument.Fields("Month").GetSelectedValues

for i=0 to val.Count-1

if val.Item(i).IsNumeric then

msgbox(val.Item(i).Number)

else

msgbox(val.Item(i).Text)

end if

How to read Multibox object value in macro?

m_woolf — Mon, 07 May 2012 17:57:56 GMT

This is also from the APIGuide:

sub test
     x=ActiveDocument.GetSheetObject("MB07").GetRelevantSelections
     for i = lbound(x) to ubound(x)
          msgbox(x(i))
     next
end sub

How to read Multibox object value in macro?

Tue, 08 May 2012 06:44:29 GMT

Thanks a lot. It is working now.