topic Limit for GetPossibleValues in QlikView

Limit for GetPossibleValues

amars — Fri, 04 Dec 2009 12:51:44 GMT

Hi all,

I am writing a macro in which I make use of GetPossibleValues , like this

set SupervisorNames = ActiveDocument.fields("Supervisor Name").GetPossibleValues

For i = 0 to SupervisorNames.Count -1

but now when I see the debug this macro to see the value of SupervisorNames.Count it is coming as 100 but my actual count of Supervisor names is aroud 400. Is there some limit for the GetPossibleValues or what?

Please help it is urgent.

Regards

Amar

Limit for GetPossibleValues

Fri, 04 Dec 2009 13:00:20 GMT

try this one

set SupervisorNames = ActiveDocument.fields("Supervisor Name").GetPossibleValues ("500")

this will get upto 500 values

regards

Peter

Limit for GetPossibleValues

amars — Fri, 04 Dec 2009 14:08:55 GMT

Thanks a lot Peter, that solved my problem.

Limit for GetPossibleValues

thierrytt1102 — Wed, 04 Apr 2012 14:50:22 GMT

you saved me life!