Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
evansabres
Valued Contributor

Select in Field

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

1 Solution

Accepted Solutions
Highlighted

Re: Select in Field

Try to load it like this

Hour([Business Hour] as Time

and then may be just this

'>=17<=19'

View solution in original post

3 Replies
Highlighted

Re: Select in Field

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

Highlighted
evansabres
Valued Contributor

Re: Select in Field

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

Highlighted

Re: Select in Field

Try to load it like this

Hour([Business Hour] as Time

and then may be just this

'>=17<=19'

View solution in original post