Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Trigger and Expression Help

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

12 Replies
Highlighted
Specialist II
Specialist II

Re: Trigger and Expression Help

Hi

did you think of using Alert  tool ?

regards

Highlighted

Re: Trigger and Expression Help

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')

Highlighted
Creator
Creator

Re: Trigger and Expression Help

Yes But not getting output.

Highlighted
Creator
Creator

Re: Trigger and Expression Help

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.

Highlighted
Creator
Creator

Re: Trigger and Expression Help

Hi Folks,

Can anyone help me on the same ?

Thanks & Regards,

AK

Highlighted
Creator
Creator

Re: Trigger and Expression Help

Hi Folks,

Can anyone help me on the same ?

Thanks & Regards,

AK

Highlighted

Re: Trigger and Expression Help

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.

Highlighted
Creator
Creator

Re: Trigger and Expression Help

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

Highlighted

Re: Trigger and Expression Help

I'm Using personal edition.