Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
schmidtj
Creator II
Creator II

SET ANALYSIS | Within last 24 hours

Hi,

i would like to build an KPI which gives me a count of data (tasks) where the last failed reload time is newer than 24 hours. 

 

My KPI of last reload failure is: timestamp(Max({<[Reload Failure]={1}>} [Reload Finish]))

 

My problem is now to buold that KPI:

Count
(
  {
    <
      [Reload Failure]={1},

      # ? Last reload failure within last 24 hours ? #
    >
  }

  [Task App Name]
)

 

Anybody an idea how to do that with SET ANALYSIS?

 

Thanks,

John

14 Replies
schmidtj
Creator II
Creator II
Author

2019-04-09 14_37_27-Window.png

Attached youll see my table with the tasks and their last successfull execution time. They are ordered ascending by execution time. I am trying to build a KPI now, which gives my all unique tasks, where the date in that table (last successful execution time) is older than 24 hours.
sunny_talwar

How is success defined? Using the flag?

schmidtj
Creator II
Creator II
Author

Yes: [Reload Failure] = {0}

sunny_talwar

Try something like this

Count({<
[Task App Name] = {"=Max({<[Reload Failure] = {0}>} [Reload Finish]) = Max([Reload Finish])"},
[Reload Finish] = {">=$(=TimeStamp(Now(1) - 1))"}
>} [Task App Name])
schmidtj
Creator II
Creator II
Author

Thanks a lot, this code helped!