Discussion Board for collaboration related to QlikView App Development.
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
Try to load it like this
Hour([Business Hour] as Time
and then may be just this
View solution in original post
How do you create Time field in the script? Can you share the script you use to create it?
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