Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to create an alert on this sql code I believe it uses bitwise operators, I don't know what that is at all but I was wondering If I can create an alert on this and if someone can help me explain to me the sql code it self, select * from Roles where roletype=0 and (supervisor1 & 4096)<>0 so if this comes back with a row I need to send an alert out with relevant data. or something that says alert. select * from UserAllPermissions where DepartmentID =0 and (supervisor1 & 4096)<>0 same thing with this one. there are multiple but if you can explain to me what to do on qlikview and if this can be implemented I would appreciate it if you can let me know.
check out document with steps to implement alert and email sending in qlikview.
CREATING AUTOMATED ALERTS AND EMAILS SENDING BASED ON DATA LOADED IN QLIKVIEW.docx
Hi,
what kind of alert? explain more or put an example to be easier help you
alert what could be? a flag in the script?
coulb be to send mail and notice that the condition its true
could be many ways
tell me more please to help you
Fernando
my apologies I meant an alert like an email that can be sent out or even a message on the screen when the condition is meant. I honestly don't understand this condition but when I run it on the database it does pull a row out.
check out document with steps to implement alert and email sending in qlikview.
CREATING AUTOMATED ALERTS AND EMAILS SENDING BASED ON DATA LOADED IN QLIKVIEW.docx