topic Getting possible values by macro in QlikView

Getting possible values by macro

Tue, 24 Apr 2012 09:44:03 GMT

Hi Everyone,

I´m new to QlikView and I want to get the possible (not the selected) vaules from a Listbox (LB21).
I tried GetPossibleValues, but it doesn´t work.

How can I get the values?

Thanks a lot.
Marcel

Re: Getting possible values by macro

Anonymous — Tue, 24 Apr 2012 10:18:41 GMT

Hope the attached file will be help ful for your requirement

Regards

Ashok

Getting possible values by macro

Anonymous — Tue, 24 Apr 2012 10:25:54 GMT

It maybe not working because of the large number of possible values. The default limit is 100. You can increase it by adding a parameter, for example:
...GetPossibleValues(1000)

Regards,
Michael

Getting possible values by macro

Tue, 24 Apr 2012 11:57:03 GMT

Hi @all,

thanks for your quick reply. It works fine.
I only need the first entry, so it works very well. 🙂

Regards,
Marcel