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 lines it is possible to make it 1 line ?

Hi All

I need to make the list box display from 2 line into 1 line :-

when i select BRAND_P = HAKKO , it will display Transport = 1.03

when i select BRAND_P = GE , it will display Transport = 1

In my script , i have below :-

lET TRANSPORT_GE = 1;

lET TRANSPORT_HAKKO = 1.03;

Paul

1 Solution

Accepted Solutions
Sokkorn
Honored Contributor

Re: Re: Re: input box 2 lines it is possible to make it 1 line ?

Hi Paul,

Let create new variable

vDisplayTransport = =If(Match(BRAND_P,'GE'),TRANSPORT_GE,TRANSPORT_HAKKO)

In Input box use variable vDisplayTransport

See sample attached file

Regards,

Sokkorn

12 Replies
Not applicable

Re: input box 2 lines it is possible to make it 1 line ?

Hi,

I cant open your qv file

vikasmahajan
Honored Contributor III

Re: input box 2 lines it is possible to make it 1 line ?

As of date I thing there is no such facility is available in Qlikview But you can use Straight Table and use 2 dimensions

Such as please refer jpg.

Vikas

Not applicable

Re: input box 2 lines it is possible to make it 1 line ?

Hi Vikas

Thank you for your sharing. i take note on this.

By the way you able to open my QVW file ?

Paul

Sokkorn
Honored Contributor

Re: input box 2 lines it is possible to make it 1 line ?

Hi Paul,

After read through your post and check your app, still not sure why you use input box to show such info. Can you share your idea why you choose input box and try to reduce one line?

My idea (may not what you looking for) is create text object with expression below:

=If(IsNull(GetFieldSelections(BRAND_P)),'Please select BRAND_P',

'Transport = ' & If(Match(BRAND_P,'GE'),TRANSPORT_GE,TRANSPORT_HAKKO))

See sample attached file also.

Regards,

Sokkorn

Not applicable

Re: input box 2 lines it is possible to make it 1 line ?

see attached

Not applicable

Re: input box 2 lines it is possible to make it 1 line ?

You look Mr Bean. no wonder you are very smart. Can you share how you make it work using 1 line ?

Not applicable

Re: Re: input box 2 lines it is possible to make it 1 line ?

Hi Sir

Thank you for your sharing.

i use input box because i have many field need to display. see the attach.

Not applicable

Re: Re: input box 2 lines it is possible to make it 1 line ?

Mr Sir

I shift the table a bit , and i laugh . this consider cheating. possible to using 1 table ?

Sokkorn
Honored Contributor

Re: Re: Re: input box 2 lines it is possible to make it 1 line ?

Hi Paul,

Let create new variable

vDisplayTransport = =If(Match(BRAND_P,'GE'),TRANSPORT_GE,TRANSPORT_HAKKO)

In Input box use variable vDisplayTransport

See sample attached file

Regards,

Sokkorn

Community Browser