Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
markgraham123
Specialist
Specialist

Multibox

Hi,

I wanna restrict the selection in the multibox.

If i select W1, i wanna make W2 inactive even though, if there were common keys in both.

So, a user can make only one selection from multibox at a time.

4 Replies
Anonymous
Not applicable

instead of using W1 and W2 in multibox, use

=if (GetSelectedCount(W2)=0, W1)  for W1

=if (GetSelectedCount(W1)=0, W2) for W2

and give the Expression the Label of W1 and W2

if you select anything from W1, W2 will Show "-"

markgraham123
Specialist
Specialist
Author

Hi Rudolf,

I tried the above expression,

but its not showing any field,

please see the attached qpp.

Anonymous
Not applicable

why are A and B in both tables (a and b) with same ID and other not? what do you want to achieve at end?

I need more to test

markgraham123
Specialist
Specialist
Author

Hi Rudolf,

consider W1 as reserve and W2 as active. 'A' and 'B' warehouse has both reserve and active

ID 1 and 2 were present in both W1 and W2 (I.e. reserve and active)

Because same ID may be contained in warehouse but want to be showed differently as it comes from different source table.

So,  while selecting the warehouse i dot wanna overlap the selections and want to isolate W2 selection wqqhen W1 is selected.