topic Re: Error in script !! in QlikView

Error in script !!

nikhilgarg — Fri, 12 Dec 2014 07:24:04 GMT

Hey,

I want to sum the duration of time as per following script but it is showing me 00:00:00

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

What's wrong in this ??

Re: Error in script !!

Fri, 12 Dec 2014 07:31:29 GMT

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

try this expression ..

Re: Error in script !!

nikhilgarg — Fri, 12 Dec 2014 07:46:06 GMT

Hey,

I tried this but it doesnot work out.

It still showing 00:00:00

Re: Error in script !!

arulsettu — Fri, 12 Dec 2014 07:53:07 GMT

try like this

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

Re: Error in script !!

MK_QSL — Fri, 12 Dec 2014 08:17:17 GMT

CHECK ENCLOSED FILE

Re: Error in script !!

jonathandienst — Fri, 12 Dec 2014 08:46:37 GMT

If KeyDowntime_StartTime and KeyDowntime_EndTime are fields, and you are attempting a row-by-row comparison, it won't work, because set analysis does not work like that. The set expression is evaluated once, not row by row.

You have two options -

Use a Sum(If(...)) expression. This will do the comparison row by row, but will perform poorly on large data sets

Create a flag field in your load script

LOAD .....

If(KeyStartTime >= KeyDowntime_StartTime And KeyStartTime <= KeyDowntime_EndTime, 1, 0) As DTFlag,

....

and use the flag in the set expression

HTH

Jonathan