topic Re: Right value when using multi box and expressions in QlikView

Right value when using multi box and expressions

Wed, 16 May 2012 14:02:21 GMT

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 — Wed, 16 May 2012 15:51:12 GMT

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

Cheers - DV

Fri, 18 May 2012 08:11:04 GMT

See attached sample.

Mon, 25 Jun 2012 11:54:35 GMT

Hi Deepak.

Do you have any suggestions to solve this issue?

Thanks in advance for any reply.

IAMDV — Thu, 12 Jul 2012 10:05:32 GMT

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

Thu, 12 Jul 2012 10:10:21 GMT

Yes.