topic Re: Conditional Dimension based on list box selections in QlikView

Conditional Dimension based on list box selections

robmarr789 — Sat, 16 Nov 2024 03:29:52 GMT

I'm trying to create a chart than will add and remove individual dimensions(columns) when they are selected or un-selected in a list box.

I've found a solution that works but only for the first 6 dimensions. When a 7th is selected from the list box all of the dimensions are removed.

Could anyone take a look at the attached and advise of an expression that will allow an infinite about of dimensions to be added if required?

Note: all dimensions should not appear until they are selected. Each should be controlled independently so that they can be added or removed individually based on the selection.

Thanks

Re: Conditional Dimension based on list box selections

lironbaram — Thu, 23 May 2019 12:44:03 GMT

all you need to do is change this part of your show hide expression

GetFieldSelections(FieldSelectionChild,'@',50)

you need to add a number selected items that will be display in detailed 50 in the example

other what happen when you select the 7th value

the getfieldselections function returns something like 7 out of 24 and not the details of the selected values

Re: Conditional Dimension based on list box selections

robmarr789 — Thu, 23 May 2019 13:32:50 GMT

Excellent, that worked.

You're a great man

Re: Conditional Dimension based on list box selections

lironbaram — Thu, 23 May 2019 13:40:53 GMT

always happy to help

Re: Conditional Dimension based on list box selections

MEJ — Fri, 24 May 2019 10:39:00 GMT

I see that you have used the "@" sign in the conditional dimensions. What does that do?