Available Fields as selection list

[#1]

Hi,

I'm looking for a way to use fields as possible selections in a list or combo-box.

I tried to create a list box with $Field. This shows the requested list of possible selections, but selecting one of them doesn't affect the created charts and tables ?

The origin of the data is a set of Excel-Sheets (for each year one sheet), all with the same field names as labels. Target is to select one of the labels from the selection list, resulting in corresponding charts and tables.

How can I solve this problem ?

Kind regards,

Stijn

[er_mohit]

Hii

create variable

value=SubField( GetCurrentSelections(),':',-1)

and use this variable in your charts and tables

in layout tab tick on radio button -->conditional there you put that variable name i.e value here

=value

hope it helps you

[#3]

call the variable as $(Field)

CREATE VARIABLE,

Field  then write its value as

=subfield(GetCurrentSelection(),':',-1)

then for testing

take Text object

and write, $(Field)

[#4]

Thanks for the quick response, but it doesn't appear to have the expected results.

The variable shows the value of the last selection (as expected), but the values of the labels can't be selected.

Probably because I'm not doing it correctly.

Perhaps a screenshot to explain what I'd like to have.

The source data look like this.

The labels in the red circle need to be the items in the selection list.

So when I select "Label1", the chart shows the values for "Label1" for dimension "Date".

Can you perhaps include a screenshot on how to declare this variable or a short qvw-example ?

Thanks in advance !

[#5]

I'm using QV 10 SR2 (QV11 not approved yet by our IT-Department).

Is there a solution to the issue for this version ?

[Gysbert_Wassenaar · Accepted solution]

Use $(=$Field) as calculated dimension. See attached example.

[#7]

Could you add a screenshot? I have the Qlikview Personal Edition, so I can't open other people's files.

Thanks in advance