topic Re: time comparison in set analysis in QlikView

time comparison in set analysis

laujerry — Thu, 05 Sep 2013 07:08:33 GMT

i want to filter data according to the time field "create_time" in an expression:

Count(

{$<

[create_time]={'>=$(=$(time_1530))'}

DISTINCT [order#]

)

"time_1530" is defined as Time#('15:30')

then it shows no data at all

by removing the set analysis the result shows properly

so is there any problem with my expression?

thanks for any help

Re: time comparison in set analysis

Thu, 05 Sep 2013 07:17:03 GMT

Try changing the simple quotations ( ' ) with double quotations ( " ). Sometimes it only works this way

Re: time comparison in set analysis

laujerry — Thu, 05 Sep 2013 07:20:42 GMT

thanks for your prompt response, but it does not work too

Re: time comparison in set analysis

Thu, 05 Sep 2013 07:30:30 GMT

Change the "time_1530" SET variable from Time#('15:30') to Time('15:30').

PFA

Re: time comparison in set analysis

laujerry — Thu, 05 Sep 2013 07:58:54 GMT

ur attachment works fine

but it just does not work for mine

Re: time comparison in set analysis

Thu, 05 Sep 2013 08:03:55 GMT

So I think that the only possibility is that the [create_time] field is not properly created and QV cannot compare it to a time value. It would be helpful if you could post more information about how it's created in the script.

Re: time comparison in set analysis

laujerry — Thu, 05 Sep 2013 08:14:34 GMT

actually i hv such a suspicion before

but then i hv tested it with a text object

=if([create_time]<$(time_1530),'yes','no') // with listbox selection of 1 value only

and it works fine, so i expect the create_time should be in proper data type

for your information, my data source is sap

i load the create_time field without any data type casting

Re: time comparison in set analysis

Thu, 05 Sep 2013 08:18:20 GMT

I'm running out of ideas.... the last one I have, have you tried changing the SET variable for a LET variable?

Re: time comparison in set analysis

laujerry — Thu, 05 Sep 2013 08:21:03 GMT

i create the var in settings->variable directly

does it matter?

Re: time comparison in set analysis

adnan_rafiq — Thu, 05 Sep 2013 08:35:57 GMT

try converting both these in number format. that is while loading user this in scripting num(create_time) as create_time ,

while creating variable for time user which you are using in the set analysis again use num.

As you are using comparison of greater than or less than it might be an issue of comparing. Set analysis some times take it as text field rather than numeric

Re: time comparison in set analysis

Thu, 05 Sep 2013 08:49:47 GMT

Can you upload your sample QVW?

Re: time comparison in set analysis

laujerry — Fri, 06 Sep 2013 01:13:43 GMT

well it seems not working

Re: time comparison in set analysis

laujerry — Fri, 06 Sep 2013 01:17:05 GMT

hi all, please find the attached file for my issue

thanks all for helping again

Re: time comparison in set analysis

Fri, 06 Sep 2013 02:34:38 GMT

Hi Jerry,

Would like to know is the field "create_time" really a time? Why I asked this is because when I convert it to a number by using num(create_time), it gives me a negative number. But your variable time_1530 is a positive number and that's why your formula does not work. If you can get the field create_time back to a normal time field, everything should work ok.

Herman

Re: time comparison in set analysis

laujerry — Fri, 06 Sep 2013 03:36:34 GMT

i reloaded with Time#(create_time,'hh:mm:ss') and it's all done

thanks a lot!

Re: time comparison in set analysis

laujerry — Fri, 06 Sep 2013 03:39:25 GMT

so it turns out that u are rite Garcia..

then i don't understand why the text object testing works