Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
lukasza163
Contributor
Contributor

dynamic dimensions and expressions in a chart

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

3 Replies
jwjackso
Specialist III
Specialist III

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

 

DynamicChart.PNG

lukasza163
Contributor
Contributor
Author

Thanks for your answer.

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

 

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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