Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Input box 2 line how to reduce to 1 line using expression ?

Hi All

I have input Box , now need to use 2 line to display the exchange rate , i hope it can just using 1 line.

if user select BRAND_P=GE or HAKKO , display USA_SGD

if user select BRAND_P=BECKHOFF , display EURO_SGD

My exchange rate field is define by :-

lET EURO_SGD = 1.8;

lET USA_SGD = 1.4;

I follow example given by SOK :-

=

If(Match(BRAND_P,'GE'),TRANSPORT_GE,

If(Match(BRAND_P,'BECKHOFF'),TRANSPORT_BK,

TRANSPORT_HAKKO))

Below is the expression i imagine , it cannot work :-

If(Match(BRAND_P,'GE'),USA_SGD,

If(Match(BRAND_P,'BECKHOFF'),EURO_SGD,

USA_SGD))

Hope some one can help me.

Paul

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Re: Input box 2 line how to reduce to 1 line using expression ?

PFA.

use expression like below for the variable v_Display_Exchange:

=Pick(Match(BRAND_P,'GE','BECKHOFF'),USA_SGD,EURO_SGD)

4 Replies
Not applicable

Re: Input box 2 line how to reduce to 1 line using expression ?

Hi All

Can some one advise me on this ?

Paul

Highlighted
MVP
MVP

Re: Re: Input box 2 line how to reduce to 1 line using expression ?

PFA.

use expression like below for the variable v_Display_Exchange:

=Pick(Match(BRAND_P,'GE','BECKHOFF'),USA_SGD,EURO_SGD)

Not applicable

Re: Input box 2 line how to reduce to 1 line using expression ?

Hi Paul,

  PFA..........Hope it will help you..........

Regards,

Nirmal.

Not applicable

Re: Input box 2 line how to reduce to 1 line using expression ?

Hi Nirmal

Thank you very much for your sharing . you approach work fine. But the Tres solution is more neat :-

=Pick(Match(BRAND_P,'GE','BECKHOFF','HAKKO'),USA_SGD,EURO_SGD,USA_SGD)

Paul

Community Browser