Right value when using multi box and expressions

[#1]

Hi All.

I´m using a multi box and in some expressions I would like to "group" two or more fields like:

Example: Table 1 - Car=1 if customer have car else 0.

                Tabel 2 - Boat=1 if customer have boat else 0.

=if(Car=1, 'Car',

   if(Boat=1, 'Boat'))

And in multi box displayed field "Vehicle" and then Car or Boat. If you choose Car then you will have all customers that have cars(1), nothing else.

This solution is not working that good. Is there some one that have any solution?

Thanks in advance

[IAMDV]

Please can you post the sample QVW file? I mean whatever you have got so far...

Cheers - DV

www.QlikShare.com

[#3]

See attached sample.

[#4]

Hi Deepak.

Do you have any suggestions to solve this issue?

Thanks in advance for any reply.

[IAMDV]

Do you still have the problem? Sorry for delayed response.

[#6]

Yes.