I have a an QVW, Where QVD Name, Current QVD Size, Current QVD Time, History QVD Time and History QVD Size.
Now I want to trigger, whenever it get refresh, If Current QVD Size increased or decreased by 10%, It should to send an email for notification with entire details.
So can anyone help me on this.
For ref. Please find attached qvw.
Thanks & Regards,
Create expression like this in the message box, add other options in the mail alert.
=if([QVD Size]=peek([QVD size]),'No Change','Change')
Thanks for mail. Can u many the same changes in my attached QVD and return back to me on the same. Because I am not able make the expression for --> Once my QVW refreshed --> So if my Current QVD Size increased or decreased by 5%, Then it should be triggered to my mail id.
By the mean time I am trying my end.
Thanks for the same.
Assume data may be like below:
QVD Name, Current QVD Size, Current QVD Time, History QVD Time, History QVD Size, size varaince
1, 50mb, date 12:30pm, date 11:30am, 45mb, 11%
2, 50mb, date 12:20pm, date 11:20am, 44mb, 13.6%
3, 35mb, date 12:10pm, date 11:10am, 20mb, 75%
4, 97mb, date 11:45am, date 11:05am, 95mb, 2.1%
5, 88mb, date 11:30am, date 10:10am, 94mb, (6.38%)
num([Current QVD Size]-[History QVD Size])/[History QVD Size]*100,'#,##0%; (#,##0%)') as [size variance] (Derive this extra field)
[Size variance] > '5%' or [size variance] < 0%
=’QVD Size increased of ‘
& [size variance]
& 'for' & [Current QVD Size] & 'On' & [History QVD Size]
Events - On Post reload.
I tried too much the same in QVW. But not able to do the same.
At least u make the required change in attached qvw and send it to me. Mail Configuration I will do my self, But varience part or logic part include in this attached qvw.
Thanks & Regards,