Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
I cant open your qv file
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
Hi Vikas
Thank you for your sharing. i take note on this.
By the way you able to open my QVW file ?
Paul
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
see attached
You look Mr Bean. no wonder you are very smart. Can you share how you make it work using 1 line ?
Hi Sir
Thank you for your sharing.
i use input box because i have many field need to display. see the attach.
Mr Sir
I shift the table a bit , and i laugh . this consider cheating. possible to using 1 table ?
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