topic Re: send alert in QlikView

send alert

Mon, 07 Oct 2013 11:04:26 GMT

i want to send a field in mail after relaod. how to send a field in alert option on the basis of reload time. i want to send different field on diffrerent reload time.

Re: send alert

Mon, 07 Oct 2013 11:06:36 GMT

In the tools menu, there's 'Alerts' and the 'Alerts Wizard' which may be able to help you

Re: send alert

Anonymous — Mon, 07 Oct 2013 11:28:03 GMT

Piyush

When you are creating the Alert Message, you can use any expression you wish, similar to as you can in a Text Box. Indeed testing your expression in a Text Box can save one having to do repeated reloads to test.

So in your expression you can do something like:

if ( now() = 'what you want it to equal', 'Text A' , 'Text B' )

Also good practice to put the reload time into a variable in the load script, as in:

let vLastLoadStart = now() ;

and use that in the Alert Message expression.

Best Regards, Bill

Re: send alert

Mon, 07 Oct 2013 12:30:18 GMT

hi bill,

i am using if condition to display field on the basis of reload time as if((reloadtime())>='1:30:00AM' and (reloadtime()<'10:30:00AM' and date(reloadtime())=date(today()),concat('field'))) in alert box. but it is not working as i am testing it in text box. please help.

Re: send alert

Anonymous — Mon, 07 Oct 2013 12:37:31 GMT

Piyush

You probably need get everything into date format, as in something like:

if( date(reloadtime() ) >= .....

then get what you what next in date format, using date# and date.

Just search for QlikView date format in Google and you'll find loads of hits.

Best Regards, Bill

Re: send alert

Mon, 07 Oct 2013 12:40:20 GMT

hi bill,

for time i m using (time(reloadtime())) and for comapring date i m using date(reloadtime()). but its not working.

Re: Re: send alert

Anonymous — Tue, 08 Oct 2013 15:48:13 GMT

Piyush

This works fine in text box:

= 'Last Reloaded: ' & reloadtime() & chr(10) & if ( hour(reloadtime()) < 17 , 'Reload before 17:00' , 'Reload at or before 17:00' )

Best Regards, Bill

Re: send alert

Wed, 09 Oct 2013 05:52:53 GMT

Hi Bill,

thanx.its working now.

Regards

Piyush Jain