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

[#1]

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

[#2]

Hi,

I cant open your qv file

[vikasmahajan]

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

[#4]

Hi Vikas

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

By the way you able to open my QVW file ?

Paul

[Sokkorn]

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

[#6]

see attached

[#7]

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

[#8]

Hi Sir

Thank you for your sharing.

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

[#9]

Mr Sir

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

[Sokkorn · Accepted solution]

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