topic how to display field values in inputbox dropdown in QlikView

how to display field values in inputbox dropdown

Wed, 11 May 2011 06:39:20 GMT

Hello,

I have a problem with inputbox dropdownlist that doesn't display all the values in a particular field.

Here is my explanation..

I have differant fields like("starttime","endtime","startdate","enddate") and i have taken 4 inputboxes to display respective fielld values in the dropdown,but i didn't get those values in the dropdown and also when i am selecting the startdate how to show the default starttime and same as enddate,endtime in all the inputboxes.

Is it possible ...????

if possible reply me with ur suggestions and let me know how to do it....

Thanks and With Regards.....

how to display field values in inputbox dropdown

brenner_martina — Wed, 11 May 2011 06:49:35 GMT

Hi, Ravikumar,

you can use the function concat(field,',') to find all filedcontents and put them as a list in an inputfield:

=Concat(Time(Timestampfield,'hh:mm'),',')

resp.

=Concat(Date(Timestampfield,DD.MM.YYYY),',')

best regards

how to display field values in inputbox dropdown

Wed, 11 May 2011 07:24:47 GMT

hello brenner,

Thank you very much for your reply and it is working well thanks a lot

now i need to defalult value like

when i am seelcting the start date to get the default start time in start time input box.

plz help me on this

Many Thanks brenner.