topic Re: alert with set analysis in QlikView

alert with set analysis

Tue, 18 Jun 2013 13:31:04 GMT

hi all

i wont to create alert , i think its with set analysis

the alert need to show me by this conditions

1.counter that bring me the result, like sum(x)/sum(y) <97%

and

2.diemension is machine name

the alert must to be together 1+2

thanks

Tue, 18 Jun 2013 13:45:36 GMT

i need also to know the last date change only, but to check all the dates in the sql

Tue, 18 Jun 2013 13:46:05 GMT

i need also to know the last date change only, but to check all the dates in the sql

Wed, 19 Jun 2013 05:15:28 GMT

someone?

Wed, 19 Jun 2013 05:21:33 GMT

Alert won't work dimension wise..

But if you want check condition on machine wise then you can use aggr() like below.

=Min(Aggr(Sum(x)/Sum(y),[Machine Name]))<0.97

Hope it helps..

Thu, 20 Jun 2013 08:24:56 GMT

KARTHIKS THANKS

THIS FORMULA GIVES ME THE LAST DATE ONLY

OR THE ANSWER ABOUT ALL THE DAYS

I NEED TO CHECK ALL THE DAYS BUT TO SEE THE CHANGE ONLY IN THE LAST DATE

Thu, 20 Jun 2013 08:42:15 GMT

The above experssion will calculate Sum(x)/Sum(y) on machine wise and If any single machine (Sum(x)/Sum(y))

go less than 97% means then it will throw alert message..

If you want to do same calculation for Machine wise and Day wise means then small change required on expression.

Like below,

=Min(Aggr(Sum(x)/Sum(y),[Machine Name],[DateField]))<0.97

If possible, please share sample file ..

Karthik

Thu, 20 Jun 2013 10:03:38 GMT

THANKS AGAIN

HOW I GET WITH DATE FIELD,

ONLY THE LAST DATE CHANGING?