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

[sona_sa]

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,

AK

[ogautier62]

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

[balabhaskarqlik]

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.