topic Re: Available Fields as selection list in QlikView

Available Fields as selection list

Tue, 30 Apr 2013 09:42:00 GMT

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

Re: Available Fields as selection list

er_mohit — Tue, 30 Apr 2013 11:08:28 GMT

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

Re: Available Fields as selection list

Tue, 30 Apr 2013 11:21:36 GMT

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)

Re: Available Fields as selection list

Tue, 30 Apr 2013 12:35:47 GMT

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 !

Re: Available Fields as selection list

Tue, 30 Apr 2013 15:54:29 GMT

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

Is there a solution to the issue for this version ?

Re: Available Fields as selection list

Gysbert_Wassenaar — Tue, 30 Apr 2013 17:59:36 GMT

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

Re: Available Fields as selection list

Tue, 11 Feb 2014 14:46:55 GMT

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

Thanks in advance