Discussion Board for collaboration related to QlikView Deployment.
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;
Go to Solution.
Let create new variable
vDisplayTransport = =If(Match(BRAND_P,'GE'),TRANSPORT_GE,TRANSPORT_HAKKO)
In Input box use variable vDisplayTransport
See sample attached file
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.
Thank you for your sharing. i take note on this.
By the way you able to open my QVW file ?
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.
You look Mr Bean. no wonder you are very smart. Can you share how you make it work using 1 line ?
Thank you for your sharing.
i use input box because i have many field need to display. see the attach.
I shift the table a bit , and i laugh . this consider cheating. possible to using 1 table ?