topic Re: Error in Script !! in QlikView

Error in Script !!

nikhilgarg — Thu, 11 Dec 2014 09:47:24 GMT

I used following script but still it is showing : 00:00:00

=Sum({<Event= {'Server_DOWN'} , KeyStartTime= {">= KeyDowntime_StartTime"}, KeyEndTime= {"<= KeyDowntime_EndTime"} >} Duration)

Please Help.

Thanks

Re: Error in Script !!

yduval75 — Thu, 11 Dec 2014 09:49:10 GMT

=Sum({<Event= {'Server_DOWN'} , KeyStartTime= {">= $(=only(KeyDowntime_StartTime))"}, KeyEndTime= {"<= $(=Only(KeyDowntime_EndTime))"} >} Duration)

Re: Error in Script !!

maleksafa — Thu, 11 Dec 2014 09:52:23 GMT

can you share with us a sample document?

Re: Error in Script !!

MK_QSL — Thu, 11 Dec 2014 09:52:38 GMT

=Sum({<Event= {'Server_DOWN'} , KeyStartTime= {">= $(=Min(KeyDowntime_StartTime))"}, KeyEndTime= {"<= $(=Max(KeyDowntime_EndTime))"} >} Duration)

Re: Error in Script !!

its_anandrjs — Thu, 11 Dec 2014 09:52:55 GMT

Once try this way

=Sum({<Event= {'Server_DOWN'} , KeyStartTime= {">=$(=KeyDowntime_StartTime)"},

KeyEndTime= {"<=$(=KeyDowntime_EndTime)"} >} Duration)

Regards

Anand

Re: Error in Script !!

nikhilgarg — Thu, 11 Dec 2014 09:54:31 GMT

HEy,

It is also not working !!.

What to do ??

Re: Error in Script !!

nikhilgarg — Thu, 11 Dec 2014 09:55:54 GMT

Hey,

It is also not working !!

Re: Error in Script !!

nikhilgarg — Thu, 11 Dec 2014 09:57:07 GMT

It is alos not working !!

Re: Error in Script !!

MK_QSL — Thu, 11 Dec 2014 09:57:52 GMT

What is the format of

KeyStartTime

KeyDowntime_StartTime

and

KeyDowntime_EndTime

Re: Error in Script !!

nikhilgarg — Fri, 12 Dec 2014 05:54:16 GMT

Hey,

You script is giving me time but i dont want min and max function. And without that it is showing me : 00:00:00

Format of

KeyStartTime

KeyDowntime_StartTime

and

KeyDowntime_EndTime

is numbers.

What to do ??

Re: Error in Script !!

MK_QSL — Fri, 12 Dec 2014 08:16:27 GMT

CHECK ENCLOSED FILE...