topic Automated emails on Reload in QlikView

Automated emails on Reload

Mon, 18 Apr 2011 09:09:50 GMT

We run a production line with batches, it consists of our packed goods (finsished goods), rebinned goods (side/by product) and our varience as we are dealing with kg averages.

now i can calculate every batch % etc and every batch has a "finalised" tag which is a yes or no.

Is it possible to write a script that will on reload send a mail to a specified email adress if the batch is "finalised=yes" and the packed goods % < 90%?

all this without any user input.??

Automated emails on Reload

ivan_will — Mon, 18 Apr 2011 09:16:39 GMT

Use from the menu - Tools - Alerts

and read this : http://qlikviewnotes.blogspot.com/2010/09/monitoring-reload-schedule.html

Automated emails on Reload

Tue, 19 Apr 2011 08:17:51 GMT

Than Ivan

That should do the trick, now my problem is to get the condition and message right.

This is the calculation i use on one of my Gauge Charts.


sum(noofcartons.palsnap * bookmass.pk)
/
if(button_packed='PACKED',sum(weight.binsnap))
*
100

This give me my packout % that i want the condition set on. But there is more:

We work in batches (field name pn.palsnap), only when a batch is finalized (fieldname finalized.pn) must it send the mail.

Also, we have more than 400 finalized batches this year already, i only want yesterday's finalized batches (fieldname date.pn, this has the date of each batch).

Then in the content of my email i would like the message to show me my batch numbers with each packout % next to it.

H2104-0387 90%

H2104-0389 89%

H2104-0390 87%

Is this do-able of taking it too far?

Automated emails on Reload

ivan_will — Tue, 19 Apr 2011 09:29:47 GMT

Just type in the expr. box the formula (may use set analyses) and as new line - chr(10)

formula&chr(10)

&formula .....