Skip to main content

Water Cooler

This space is for everyone to ask questions related to the Community Platform. It's a space for us to get to know each other and have some fun! Come in and gather around the Water Cooler!

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
s10157754
Creator III
Creator 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
juliensaintmaxent3113
Luminary Alumni
Luminary Alumni

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
Creator III
Creator III
Author

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

juliensaintmaxent3113
Luminary Alumni
Luminary Alumni

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