topic Qlik Cloud Alerts in App Development

Qlik Cloud Alerts

Vaishnav16 — Wed, 09 Apr 2025 17:57:52 GMT

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

Re: Qlik Cloud Alerts

Chanty4u — Thu, 10 Apr 2025 05:59:31 GMT

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

Re: Qlik Cloud Alerts

Vaishnav16 — Thu, 10 Apr 2025 13:48:44 GMT

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