Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

ActiveDocument.field("foobar").GetPossibleValues

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>

3 Replies
Not applicable

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

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

Maybe you changed:

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

to

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

- Marcus

tiago_hubner
New Contributor III

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

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?

Community Browser