Trigger and Expression Help

[sona_sa]

Hi,

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,

AK

[ogautier62]

Hi

did you think of using Alert  tool ?

regards

[balabhaskarqlik]

Use these:

https://www.quickintelligence.co.uk/qlikview-alerts/

https://community.qlik.com/docs/DOC-3556

Create expression like this in the message box, add other options in the mail alert.

=if([QVD Size]=peek([QVD size]),'No Change','Change')

[sona_sa]

Yes But not getting output.

[sona_sa]

Hi Bala,

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.

[sona_sa]

Hi Folks,

Can anyone help me on the same ?

Thanks & Regards,

AK

[sona_sa]

Hi Folks,

Can anyone help me on the same ?

Thanks & Regards,

AK

[balabhaskarqlik]

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)

Create Alerts:

Condition:

[Size variance] > '5%' or [size variance] < 0%

Message:

=’QVD Size increased of ‘

& [size variance]

& 'for' & [Current QVD Size] & 'On' & [History QVD Size]

Events - On Post reload.

[sona_sa]

Hi Bala,

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.

It's urgent.

Thanks & Regards,

AK

[balabhaskarqlik]

I'm Using personal edition.