Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
danielnevitt
Creator
Creator

Input Box Selection

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

5 Replies
srchilukoori
Specialist
Specialist

Input box is used to set values to variables and you can switch values one at a time.

chiru_thota
Specialist
Specialist

You can do it with the help of variables and set analysis.Have a look at attached QVW.

Input multiple.jpg

danielnevitt
Creator
Creator
Author

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

its_anandrjs

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

its_anandrjs

Check the attached sample snap shot.

Sample2.png

Hope this helps

Thanks & Reagrds