Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Is there a Limit on GetPossibleValues of 100?

I have a script that will loop through the selected records and insert them into a SQL Table.  Before performing the For loop I grab the Unique IDs Column and then use the Count.  Even though the Table box Shows greater then 100, all I get in the following statements is 100.

set iMFGRowID = ActiveDocument.Fields("[Plan.Planned MFG Row ID]").GetPossibleValues

msgbox MFGRowID.count

This is done in the  Macro and I am using vbscript.

I would be grateful for any suggestions.

Thanks

1 Solution

Accepted Solutions
Not applicable

Is there a Limit on GetPossibleValues of 100?

Ok So I answered my own question by reviewing similar items here.

Please see the Discussion "Limit for GetPossibleValues" as this totally fix my issue.

1 Reply
Not applicable

Is there a Limit on GetPossibleValues of 100?

Ok So I answered my own question by reviewing similar items here.

Please see the Discussion "Limit for GetPossibleValues" as this totally fix my issue.