topic Re: Multibox in QlikView

Multibox

markgraham123 — Wed, 29 Jul 2015 14:44:42 GMT

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.

Anonymous — Wed, 29 Jul 2015 14:52:44 GMT

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 — Wed, 29 Jul 2015 14:58:18 GMT

Hi Rudolf,

I tried the above expression,

but its not showing any field,

please see the attached qpp.

Anonymous — Wed, 29 Jul 2015 15:38:44 GMT

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 — Wed, 29 Jul 2015 15:46:51 GMT

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.