dynamic dimensions and expressions in a chart

[lukasza163]

Hello everybody,

I want to show dynamically the dimensions and expressions of a chart.
For this I create two listboxes (with one field) one with the dimensions and the other with the expressions.

My problem is that when I have selected the dimensions and then select the expressions, the selections of the dimensions will be deselected and vice versa.

How can I solve this problem without using two fields (one for dimensions and one for expressions)?

Thanks for your help

Lukas

[jwjackso]

I believe the problem is having both the dimensions and expressions in the same field.

[lukasza163]

Thanks for your answer.

It works with two fields but I want to know if it is possible with only one field.

[rwunderlich]

You could put the listboxes in two different Alternate States.  And then adjust your GetFieldSelections to reference the state name.

GetFieldSelections(field_id,',',6,DimState)

It's a bit awkward to get the state name in GetFieldSelections(). It may be simpler syntax to write your conditional show like this:

=GetSelectedCount(field_id, False(), 'ExprState') and Max({ExprState}Match(field_id, 'F3'))

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com