topic Re: dynamic dimensions and expressions in a chart in QlikView

dynamic dimensions and expressions in a chart

lukasza163 — Thu, 07 Mar 2019 14:55:40 GMT

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

Re: dynamic dimensions and expressions in a chart

jwjackso — Thu, 07 Mar 2019 15:35:48 GMT

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

Re: dynamic dimensions and expressions in a chart

lukasza163 — Thu, 07 Mar 2019 15:54:26 GMT

Thanks for your answer.

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

Re: dynamic dimensions and expressions in a chart

rwunderlich — Thu, 07 Mar 2019 15:55:06 GMT

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