How does alert work

Thu, 22 Nov 2012 14:50:09 GMT

Hi,

I have create the following table.

LOAD * INLINE [

Salesman,NoOfProducts,year,total

Sujeet,12,2012,1000

Smita,10,2011,100,

Hari,5,2010,50

Bala,20,2012,1000]

After that i tried to create an alert with the condition "sum([TOTAL]<100) ". I am expecting something like if i reload the table and click on the row where total is 50, i should see the alert message. But I am not able to see anything. Please let me know the best use of alerts.

Next question is from my desktop how can i send the alert to my GMAIL ?

Thanks,

Sujeet

Re: How does alert work

erichshiino — Sat, 24 Nov 2012 13:11:18 GMT

Hi,

The condition will be tested during reload. In your case, you compare the result of all of them ( 2150) with 100... and it doesn't satisfy the condition ( and it should be sum([total) > 100 instead of sum( [TOTAL]<100)

You need use aggr in the expression to test each of the Salesman to identify if any of them had sum( ...) <100

the condition will be

sum( aggr( if( sum( [total]) <100,1,0), Salesman))>0

Hope it helps,

Erich

topic Re: How does alert work in QlikView

How does alert work

Re: How does alert work