topic Alternate state - how to use GetFieldSelection in QlikView

Alternate state - how to use GetFieldSelection

Wed, 18 Sep 2013 14:05:49 GMT

Throughout my document I'm using <default state> for a selected Forecast Type.

The List box for this field is set to Always one selected.

However in one of the tabs I'm trying to compare the values of two forecast types.

To get this done I've set up an alternate state <Forecast Type II>.

I've added another list box so a second Forecast Type can be selected.

So far so good.

I'm using a straight table to compare values of the choosen forecast types.

For the column header of the <default state> using GetFieldSelections() will give me the selected forecast Type.

But what do I need to do to retrieve the selected forecast type from the alternate state?

Gysbert_Wassenaar — Wed, 18 Sep 2013 14:24:43 GMT

Getfieldselections doesn't support alternate states. You can try using the concat function instead:

concat({[MyState]} distinct MyField, ','). If you have only one selected value then only({[MyState]} MyField) works too.

BenjaminCoe1440 — Thu, 23 Feb 2023 11:43:57 GMT

So happy I found this - solved my chart issue!

enozagar — Fri, 27 Sep 2024 17:43:28 GMT

Actually, GetFieldSelections support alternate states. You can try with:

GetFieldSelections(MyField, ', ', 3, 'MyState').

', ' is the separator and 3 tthe maximum number of field values to be individually listed