topic Re: Input Box Selection in QlikView

Input Box Selection

danielnevitt — Tue, 25 Mar 2014 13:57:19 GMT

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

Re: Input Box Selection

srchilukoori — Tue, 25 Mar 2014 14:11:04 GMT

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

Re: Input Box Selection

chiru_thota — Tue, 25 Mar 2014 14:23:26 GMT

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

Re: Input Box Selection

danielnevitt — Tue, 25 Mar 2014 14:29:45 GMT

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

Re: Input Box Selection

its_anandrjs — Tue, 25 Mar 2014 14:30:09 GMT

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

Re: Input Box Selection

its_anandrjs — Tue, 25 Mar 2014 14:31:48 GMT

Check the attached sample snap shot.

Hope this helps

Thanks & Reagrds