topic Re: ActiveDocument.field("foobar").GetPossibleValues in QlikView

ActiveDocument.field("foobar").GetPossibleValues

Wed, 20 Aug 2014 13:37:55 GMT

ActiveDocument.Fields("Contract_Partner").GetPossibleValues don't return all values which are displayed in the list box.

When I call the missing value ActiveDocument.Fields("Contract_Partner").Select "foobar", the exports works well.

Any hints?

Thanks for your time!

cheers

Martin

<snip>

ActiveDocument.ClearAll true
set val=ActiveDocument.Fields("Contract_Partner").GetPossibleValues

for i=0 to val.Count-1
     msgbox(val.Item(i).Text)
     set MyTable = ActiveDocument.GetSheetObject("CH918")
     ActiveDocument.Fields("Contract_Partner").Select val.Item(i).Text
     MyTable.ExportBiff  "C:\" & val.Item(i).Text &"_export" & ".xls" 
next

</snip>

Re: ActiveDocument.field("foobar").GetPossibleValues

Wed, 20 Aug 2014 14:32:33 GMT

Hi Martin, What is the purpose on this Macro first.

Try to create your app without Macro for better performance and future versions upgrades.

Re: ActiveDocument.field("foobar").GetPossibleValues

marcus_sommer — Wed, 20 Aug 2014 14:40:47 GMT

Maybe you changed:

set val=ActiveDocument.Fields("Contract_Partner").GetPossibleValues

set val=ActiveDocument.GetSheetObject("LB09").GetPossibleValues

- Marcus

Re: ActiveDocument.field("foobar").GetPossibleValues

tiago_hubner — Thu, 06 Aug 2015 00:56:55 GMT

Hi,

I think it's can be because the limitation. Like they talk here.

This can Also help you.

Re: Macro limitations of 100 iterations?