Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

Error in Script !!

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

10 Replies
yduval75
Partner - Creator III
Partner - Creator III

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

maleksafa
Specialist
Specialist

can you share with us a sample document?

MK_QSL
MVP
MVP

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

its_anandrjs

Once try this way

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

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

Regards

Anand

nikhilgarg
Specialist II
Specialist II
Author

HEy,

It is also not working !!.

What to do ??

nikhilgarg
Specialist II
Specialist II
Author

Hey,

It is also not working !!

nikhilgarg
Specialist II
Specialist II
Author

It is alos not working !!

MK_QSL
MVP
MVP

What is the format of

KeyStartTime

KeyDowntime_StartTime

and

KeyDowntime_EndTime

?

nikhilgarg
Specialist II
Specialist II
Author

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 ??