topic One field multiple list box in QlikView

One field multiple list box

vikasgupta — Wed, 15 Jul 2015 07:28:59 GMT

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

Re: One field multiple list box

Kushal_Chawda — Wed, 15 Jul 2015 07:31:47 GMT

what expression you are using to create listbox?

Re: One field multiple list box

Wed, 15 Jul 2015 07:47:45 GMT

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

Re: One field multiple list box

vikasgupta — Wed, 15 Jul 2015 07:56:31 GMT

Hi KKR,

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

Thanks

Re: One field multiple list box

avinashelite — Wed, 15 Jul 2015 07:59:38 GMT

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

Re: One field multiple list box

morganaaron — Wed, 15 Jul 2015 08:16:22 GMT

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.

Re: One field multiple list box

vikasgupta — Wed, 15 Jul 2015 09:17:48 GMT

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

Re: One field multiple list box

morganaaron — Wed, 15 Jul 2015 10:15:45 GMT

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.