Qlik Community

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

s10157754
Contributor III

Chart to display success job over 24 hours

Dear Qlikview Experts,

Capture.PNG

This is my table. Column A is the date and Time. Column B, '1' is success job and '0' is failure job. I was wondering how can i display the the success/failure job over 24 hours? So i can see among which period does the failure job occurs the most. However, I realized if I put time as the dimension, it would be very crowded. Is there any type of charts that can display the data in a better way?

I have also attached the sample excel file for your reference.

Best Regards

QianNing

3 Replies
Partner
Partner

Re: Chart to display success job over 24 hours

hi, 

may be with the function interval and relaodtime or Now

interval (now() - DATE ,'hh') 

and after conditional expression in the script :

if(interval (now() - DATE ,'hh')>24,'good','bad')

bye 

s10157754
Contributor III

Re: Chart to display success job over 24 hours

Dear Jsaintmaxent,

Thank you for your suggestion, are you able to give me a detailed explanation or could you send me the modified qvw file to easy my reference? 

Thank you so much!

Best Regards

QianNing

Partner
Partner

Re: Chart to display success job over 24 hours

hi,

in attachment, you have got an example.

Open script editor to view the function interval

Have a nice day

Do not hesitate to contact me