Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use $(=$Field) as calculated dimension. See attached example.
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
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)
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 !
I'm using QV 10 SR2 (QV11 not approved yet by our IT-Department).
Is there a solution to the issue for this version ?
Use $(=$Field) as calculated dimension. See attached example.
Could you add a screenshot? I have the Qlikview Personal Edition, so I can't open other people's files.
Thanks in advance