topic Re: Error in Script !! in QlikView

Error in Script !!

nikhilgarg — Thu, 11 Dec 2014 06:58:55 GMT

HEy,

I am having error in following script.

Can you tell me what is the error ??

I have to Sum the Duration for Event = Server_DOWN and (StartTime >= Downtime_StartTime) and (EndTime <= Downtime_EndTime)

Script :

=Sum({<Event = {'Server_DOWN'} and PurgeChar(Time(StartTime, 'hh:mm:ss'), ':') >= PurgeChar(Time(Downtime_StartTime, 'hh:mm:ss'), ':') and PurgeChar(Time(EndTime , 'hh:mm:ss'), ':') <= PurgeChar(Time(Downtime_EndTime , 'hh:mm:ss') , ':')> }Duration)

Thanks

Re: Error in Script !!

alexandros17 — Thu, 11 Dec 2014 07:40:46 GMT

At first change the and into comma so :

Sum({<Event = {'Server_DOWN'} , .... Duration)

the second condition must be written again unfortunately you cannot use functions (purgechar in this case) at the left side so you need to compute that value in the script, let's say myvalue. With these conditions the expression change into:

myvalue = {'$(>=PurgeChar(Time(Downtime_StartTime, 'hh:mm:ss'), ':')<=PurgeChar(Time(Downtime_EndTime , 'hh:mm:ss') , ':') )'}

Re: Error in Script !!

anbu1984 — Thu, 11 Dec 2014 08:02:09 GMT

=If(Event = 'Server_DOWN' and PurgeChar(Time(StartTime, 'hh:mm:ss'), ':') >= PurgeChar(Time(Downtime_StartTime, 'hh:mm:ss'), ':') and PurgeChar(Time(EndTime , 'hh:mm:ss'), ':') <= PurgeChar(Time(Downtime_EndTime , 'hh:mm:ss') , ':'), Sum(Duration))

Re: Error in Script !!

nikhilgarg — Thu, 11 Dec 2014 08:59:50 GMT

Hey,

This is not working. What to do ??

Re: Error in Script !!

rajeshvaswani77 — Thu, 11 Dec 2014 09:41:59 GMT

Hi Nikhil,

Break it in small parts and make each small part work, else it will be difficult to find what's not causing it to work.

thanks,

Rajesh Vaswani

Re: Error in Script !!

nikhilgarg — Thu, 11 Dec 2014 09:43:28 GMT

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

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

Re: Error in Script !!

anbu1984 — Thu, 11 Dec 2014 09:44:25 GMT

Any errors? Can you post sample app.

In script, don't use = before If

If(Event = 'Server_DOWN' and PurgeChar(Time(StartTime, 'hh:mm:ss'), ':') >= PurgeChar(Time(Downtime_StartTime, 'hh:mm:ss'), ':') and PurgeChar(Time(EndTime , 'hh:mm:ss'), ':') <= PurgeChar(Time(Downtime_EndTime , 'hh:mm:ss') , ':'), Sum(Duration))