Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Alternate state - how to use GetFieldSelection

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?

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

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.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

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.


talk is cheap, supply exceeds demand

View solution in original post