One field multiple list box

[vikasgupta]

Hi All,

I have one field and I needs to create two list box using expression but the challenge is that selection is cleared once i am selecting in other list box. Here  I don't wants to use alternate state because I am using as dimension.

Please see the attached qvw for same.

Any help would be appreciated.

Thanks

Vikas

[Kushal_Chawda]

what expression you are using to create listbox?

[#3]

Attached QVW has only an INLINE table. Upload the QVW with the list boxes you were discussing about. And why you want to create two list boxes on same field using different expressions? I think selection in one list box will surely clear the selection in other one. There might be a workaround for you requirement. Explain that.

Regards,

KKR

[vikasgupta]

Hi KKR,

Sorry I attached wrong one . Please find the attached updated qvw.

Thanks

[avinashelite]

try to create the new field in the script then try to use it ...but the selection will made according to the data you need to take of it

[morganaaron]

Attached an example - follows the same idea, create two separate fields and then use a set expression to read these as your main region.

I've attached two charts/text boxes - one shows nothing when nothing is selected, one shows all possible values for fields without selections.

[vikasgupta]

Hi Aaron,

Thank for reply !

I don't want to create separate fields in script because

1. more than 100 fields so its not feasible.

2. If I will create separate tables then its very difficult to use as calculation condition in chart.

I am using these fields as dimension based on selection from list box similar to self-help reports.

Thanks

Vikas

[morganaaron]

Hi Vikas,

Why not just have it as one list box? As soon as you use a calculation condition you can't use 'and' mode, and so if you're selecting in one set, default behaviour will be to override any other selections.

I think you're going to have to look to alternate states or other fields, I tried using bookmarks but even this clears down due to the calculation conditions.