Advanced search and BookMark

Thu, 15 Jan 2015 07:04:55 GMT

hi, all.

i have developed a logistic model for a customer.

one of the fields is an endtime of a task, represended by HH:mm:ss.nnn

the model is working fine.

running with 11.2 sr9 on win7 32 bit.

the customer requested an ability to range a time windows of a hour,

thus i have created a variable of a starttime, and created a query in an advanced search over the endtime field:

=[EndTime]>=mid($(starttime),1,2)&':'&mid($(start),3,2)&'*' and [EndTime]<=mid($(starttime),1,2)+1&':'&mid($(start),3,2)&'*'

the input variable gets a number, like 1445, and the query dissolve the input and combine like:

=[EndTime]>=14:45* and [EndTime]<=15:45*@

the query runs fine, but each time i change the starttime variable value, and run the adv search (on GO botton), nothing happend. i need first to do a 'clear all' and the run the query again to get result.

further, when the query runs and after i bookmark the result, when i try to activate the created bookmark, i get different results.

is it a bug in the version or i do something wrong?

help be appreciated.

moti.

Re: Advanced search and BookMark

Gysbert_Wassenaar — Thu, 15 Jan 2015 10:16:19 GMT

My suggestion would be to create an EndHour field in the script and let the user select a range in that new field using a slider object.

Re: Advanced search and BookMark

Thu, 15 Jan 2015 15:41:44 GMT

thanks,

i didnt know this can be done with a slider.

also i have found that the problem with the bookmark was because there was a mark in the '+' checkbox, thus the was no clear all.

moti

topic Advanced search and BookMark in QlikView

Advanced search and BookMark

Re: Advanced search and BookMark

Re: Advanced search and BookMark