Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two fields Load_Location and Discharge_Location.
Is it possible to create an input box that will return data where the Load_Location OR Discharge_Location are for example USA?
Also is it possible to have multiple input selections ie USA, Canada, Mexico etc?
Thanks for your help.
Regards,
Daniel
Input box is used to set values to variables and you can switch values one at a time.
You can do it with the help of variables and set analysis.Have a look at attached QVW.
Hi,
Thanks for your reply.
Is it possible to do a similar thing using the calculated dimension?
I wrote the following, but it doesn't seem to work:
IF(MATCH(trim(LOAD_LOC_REF),('vCountry')),LOAD_LOC_REF,
IF(MATCH(trim(DISCH_LOC_REF),('vCountry')),DISCH_LOC_REF,null())
)
Regards,
Daniel
Yes it is possible go to input box properties -> Constraints -> select value list prefered value in list box and select list values and type your inputs USA;Canada;Mexico
Hope this helps
Thanks & Reagrds
Check the attached sample snap shot.
Hope this helps
Thanks & Reagrds