topic Re: VBA code for sheetobject selection in QlikView

VBA code for sheetobject selection

venkatasubramanian — Sat, 16 Nov 2024 20:21:52 GMT

Hi There

i have selected the sheetobject using the belwo vba code, but i am not sure how to make filter/Selection in sheetobject (CH11), could you please help me on this

Set obj = doc.GetSheetObject("CH11")

Re: VBA code for sheetobject selection

m_woolf — Mon, 29 Jul 2019 19:04:57 GMT

From the API Guide:

ActiveDocument.Fields("Month").Select "September"

ActiveDocument.Fields("Month").Select "J*"

ActiveDocument.Fields("Sales").Select ">1500"

Re: VBA code for sheetobject selection

venkatasubramanian — Mon, 29 Jul 2019 19:21:28 GMT

I have tried this but it shows "Object doesn't support this property or method" error.

I will elaborate my question for more clarity, I need to make some selection (cyclic filter selection) in the objectsheet (sheet names in default shows CH11, CH51...) before i export that in the excel file.

I have made all the selection using the code Activedocument.GetField("Month").Select "Jul" and got an output in the object sheet, now i have to export Jul month data per customer/, to do that i have to make a selection (customer) in the output (object sheet) and export it in the excel file. I need a code to select customer in the output sheet.

Re: VBA code for sheetobject selection

m_woolf — Tue, 30 Jul 2019 12:02:08 GMT

Use similar code to select a customer:

ActiveDocument.Fields("Customer").Select "Joe Blow"