Qlik Cloud Alerts

[Vaishnav16]

Hi All,

I have a table chart with System as Dim and measure as Known System Attempts Failure

Now, I have an requirement that if total of the "Known System Attempts Failure"  is more than 1% and Total System Access Attempts are >500 in rolling 24 hours send an alert

My measure as :
Known System Attempts Failure = Count of System Failures /Total System Access Attempts
If Totals turns 0.6 to 1% then I need to send alert

System     Known System Attempts Failure
Totals        0.6%(66/11,336)

ABC          0.7% (32/4279)
AEF          0.6% (32/5717) 
AJS          0.4% (5/1340)

How I can do this, How to create conditions based on above

Please help, Thanks in advance 

[Chanty4u]

Try this 

(

  Sum({< TimestampField={">=$(=Now()-1)"} >} FailureCount)

  /

  Sum({< TimestampField={">=$(=Now()-1)"} >} AccessCount)

) > 0.01

and 

Sum({< TimestampField={">=$(=Now()-1)"} >} AccessCount) > 500

You can set this expression to alert according to your frequency 

[Vaishnav16]

Hi @Chanty4u , Thanks for replying

I have now added Access Attempts in table also
For the first condition to show "Known System Attempts Failure" > 1%, I did like added like below

But for 2nd condition is if Access Attempts from yesterday is >= 500, For this I've given measure as "Access Attempts", but what to include in value to get condition if Access Attempts from yesterday is >=500 send alert

Please reply back