Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
j_schmidt
Creator
Creator

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

j_schmidt
Creator
Creator
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])

View solution in original post

j_schmidt
Creator
Creator
Author

Thanks a lot, this code helped!