Limited list box values discrepancy

[Anonymous]

Hi,

Im trying to build an ad-hoc report with dynamic dimensions. For this reason I created an excel file where QV loads the dimension information (about 50 dimensions).

dimensions:

LOAD    _dimensionNo,

              _dimensionLabel,

              _dimension,

              _group

  FROM

[$(vExternalDataPath)dimensions.xlsx]

(ooxml, embedded labels, table is Sheet1);

I would like to keep the excel file because its easier to adjust than INLINE LOAD.

This worked totally fine with adding and removing the dimensions to the report from one big list-box. Now I wanted to group the different dimensions by information into multiple list-boxes which also worked totally fine with an expression instead of field:

=IF(match(_group, 'OriginInfo'),_dimensionLabel)

Now I got my dimensions all neat and tidy sorted into 6 list-box and here comes my dilemma.

I can select multiple values from one list-box and they show up correctly. In the statusbox I can see that by clicking one value, also the linked _group is selected.

When trying to add a value from another list-box / _group the current _group gets de-selected and also the related values I selected before.

Any ideas how to work around that?

I thought about creating tables for each _group but this would not work with my dynamic dimension selection in the report

I appreciate any input!!

- Lucas

[Anonymous]

Hi Settu,

Thanks your input. That was my initial problem which I was trying to find a solution for.

I didnt know how to make different island tables work with my original formula for dynamic dimensions.

Thomas found a solution:

=$(=subfield(

                    if(len(GetFieldSelections(_dimension_DestinationInfo))>0,concat(_dimension_DestinationInfo,';'),'')

                    &';'

                    &if(len(GetFieldSelections(_dimension_GoodsInfo))>0,concat(_dimension_GoodsInfo,';'),'')

,';',1))

- Lucas

[thomaslg_wq]

Hi Lucas,

I often use this trick

No it is not necessary, I did use it to keep your data and create several dimension tables.

Thomas