Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Right value when using multi box and expressions

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

5 Replies
IAMDV
Honored Contributor II

Re: Right value when using multi box and expressions

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

Cheers - DV

www.QlikShare.com

Not applicable

Re: Right value when using multi box and expressions

See attached sample.

Not applicable

Re: Right value when using multi box and expressions

Hi Deepak.

Do you have any suggestions to solve this issue?

Thanks in advance for any reply.

IAMDV
Honored Contributor II

Re: Right value when using multi box and expressions

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

Not applicable

Re: Right value when using multi box and expressions

Yes.

Community Browser