how to calculate 24-time difference in qlisense

[Anonymous]

Hi All,

Below is my script. Ist script  output is correct. Ex: 00:47

2 nd script output is wrong. Ex: 23:13:00 PM

Required out put: 23:13

1^st script:

interval(time("To  ", 'hh:mm') - time("From   ", 'hh:mm'), 'hh:mm')as "Outage Duration",

2^nd Scropt:

interval(time('24:00', 'hh:mm')-

interval(time("To  ", 'hh:mm') - time("From   ", 'hh:mm'),'hh:mm')) as "Overall Availability"

3^rd Script:

((interval(time('24:00', 'hh:mm')-interval(time("To  ", 'hh:mm') - time("From   ", 'hh:mm'), 'hh:mm')))/24)*100 as "Overall Availability"

Qliksense output :

Regards,

Krishna

[Anil_Babu_Samineni · Accepted solution]

Can you try this?

Interval(time('24:00', 'hh:mm')- (time("To  ", 'hh:mm') - time("From   ", 'hh:mm')),'hh:mm')

[Anonymous]

Hi Anil,

How to calculate Overall Availability%

Formula: (Overall Availability/24)*100

Below script returns wrong out put.

Script:

((Interval(time('24:00', 'hh:mm')- (time("To  ", 'hh:mm') - time("From   ", 'hh:mm')),'hh:mm'))/24)*100 as AV%

Thanks,

Krishna.

[Anil_Babu_Samineni]

Instead sharing excel, Please post qvw to look. Again we need to load the data and work.