topic Re: Trigger and Expression Help in QlikView

Trigger and Expression Help

sona_sa — Thu, 30 Aug 2018 11:14:27 GMT

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,

Re: Trigger and Expression Help

ogautier62 — Thu, 30 Aug 2018 14:34:06 GMT

did you think of using Alert tool ?

regards

Re: Trigger and Expression Help

BalaBhaskar_Qlik — Thu, 30 Aug 2018 16:22:02 GMT

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

Re: Trigger and Expression Help

sona_sa — Fri, 31 Aug 2018 04:33:24 GMT

Yes But not getting output.

Re: Trigger and Expression Help

sona_sa — Fri, 31 Aug 2018 04:39:59 GMT

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.

Re: Trigger and Expression Help

sona_sa — Fri, 31 Aug 2018 06:33:19 GMT

Hi Folks,

Can anyone help me on the same ?

Thanks & Regards,

Re: Trigger and Expression Help

sona_sa — Fri, 31 Aug 2018 06:33:40 GMT

Hi Folks,

Can anyone help me on the same ?

Thanks & Regards,

Re: Trigger and Expression Help

BalaBhaskar_Qlik — Fri, 31 Aug 2018 07:42:37 GMT

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.

Re: Trigger and Expression Help

sona_sa — Fri, 31 Aug 2018 10:41:11 GMT

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,

Re: Trigger and Expression Help

BalaBhaskar_Qlik — Fri, 31 Aug 2018 11:00:49 GMT

I'm Using personal edition.

Re: Trigger and Expression Help

sona_sa — Fri, 31 Aug 2018 11:27:46 GMT

Ohk .

Then Please find the attached xls and load in your QVW apps. Make the script and expression and and send back to me. I will configure mail portion.

U can do it, very well. There is 2 Sheets.

Hope it is sufficient for you.

Regards,

Re: Trigger and Expression Help

ogautier62 — Fri, 31 Aug 2018 12:58:43 GMT

keep your expression anywhere,

suppress if, and add one by one .....

you know what ?

this particular radar is not very convenient vs your need :

- find a radard with 2nd dimension as expression

- or with this radar

add in script a field Amount and a field TypeAmount with 'Revenue','Profit' ......

so TypeAmount can be use as dimension without valuelist

Re: Trigger and Expression Help

BalaBhaskar_Qlik — Fri, 31 Aug 2018 16:05:16 GMT

In the excel sheet, copied History data into current data tab, loaded data into Qlikview by:

QVD size Data is same in both sheets, so data modified for one row.

Current:

LOAD [QVD Name],

[QVD Path],

[QVD Size (KB)],

[QVD Time],

[Historic QVD Size (KB)],

[Historic QVD Time]

FROM

(ooxml, embedded labels, table is CURRENT_QVD);

Created straight table with:

On Size variance column created Alert to get an alert on data change of first row.