topic .NET API Qlik Sense GetPossibleValues in Integration, Extension & APIs

.NET API Qlik Sense GetPossibleValues

berndpodhradsky — Tue, 14 Mar 2017 18:03:17 GMT

Hi!

In QlikView there used to be methods such as "GetPossibleValues" and "GetAllValues" etc on a field. How can I achieve the same thing with Qlik Sense? I know that the IField interface carries methods to select possible values etc but I just want to get an array of values, not actually select them.

Any idea where to start?

Bernd

Re: .NET API Qlik Sense GetPossibleValues

Øystein_Kolsrud — Wed, 15 Mar 2017 07:31:46 GMT

I think the typical way to do that would be to go through an AppField instance. It provides you with methods like AppField.GetExcluded‌ and AppField.GetOptional. I'm not sure about the the semantics of "GetPossibleValues" in QlikView, but I think GetOptional would be what you want (possibly combined with AppField.GetSelected‌.AppFields are constructed from the App through this method: AppExtensions.GetAppField‌

An example could look something like this:

var countryField = app.GetAppField("Country");
var page = new NxPage(){ Height=20, Width=1, Top=0, Left=0 };
var selectedCountries = countryField.GetSelected(page);

Re: .NET API Qlik Sense GetPossibleValues

berndpodhradsky — Fri, 31 Mar 2017 00:26:47 GMT

Thanks for pointing me in the right direction - now works perfectly fine, great!

Re: .NET API Qlik Sense GetPossibleValues

berndpodhradsky — Fri, 14 Apr 2017 11:55:01 GMT

Again, thanks for giving me that hint - could you please have a look at the following thread, where I have another question?

Total Cells via GetData

Thanks,

Bernd

Re: .NET API Qlik Sense GetPossibleValues

Øystein_Kolsrud — Tue, 18 Apr 2017 11:32:56 GMT

Done! I just posted an answer on that thread.