Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

What's wrong with my Alert expression?

Hello,

I am attempting to set up an alert that checks a threshold after my dashboard refreshes (currently reloading every 6 minutes). This monitors eCommerce traffic so it's pretty important to the business.

In the alert menu, I have the condition set as the following:

sum(if(hour(ReloadTime())>=Created_Time,ACCOUNT))/sum(if(hour(ReloadTime())>=LastWeek_Date,LastWeek_ACCOUNT/5))<.75

I am already using this same expression (minus the <.75) as a gauge in my dashboard to monitor and it works fine. The output of the expression is a value between 0 and 1 with the following thresholds for the gauge:

0-.74 =RED

.75-.99 = YELLOW

1 or greater = GREEN

I am simply trying to replicate this expression as a push alert that pops up or sends an email when the RED threshold is released, in other words, when the value is less than .75

The output to my understanding needs to be true or false values, which looks to be the case in the expression above (either 0 or -1 is returned). What am I doing wrong?

Tags (3)
1 Reply
Not applicable

Re: What's wrong with my Alert expression?

Hi Philip,

Did you manage to solve your issue ?

If not, a sample document would be helpful to test on your real case.

Regards,

JP

Community Browser