Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Champion III
Champion III

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
Champion III
Champion III

Check the attached sample snap shot.

Sample2.png

Hope this helps

Thanks & Reagrds