topic Re: Select in Field in QlikView

Select in Field

evansabres — Tue, 20 Feb 2018 20:01:00 GMT

I have a field, 'Time' for which the values are formatted as 1:00 PM, 2:00 PM, etc.

I want to build a text object with an action to select in field a few times. I want to select the values of 5:00 PM, 6:00 PM and 7:00 PM.\

I chose an action of 'Select in Field' and entered my field of Time and entered (5:00 PM|6:00 PM|7:00 PM) in the search string, but this produces no result

Re: Select in Field

sunny_talwar — Tue, 20 Feb 2018 20:02:24 GMT

How do you create Time field in the script? Can you share the script you use to create it?

Re: Select in Field

evansabres — Tue, 20 Feb 2018 20:04:16 GMT

Time is loaded in the script in the format in the same format that it is in the data, i just change the field name.

[Business Hour] as Time

Re: Select in Field

sunny_talwar — Tue, 20 Feb 2018 20:08:27 GMT

Try to load it like this

Hour([Business Hour] as Time

and then may be just this

'>=17<=19'