Quick question on alert email set for successful update

[#1]

Hi,

I am having requirement in which i am getting daily data and the same has been updated in the QVD. During monthend we have receive another input file which have the sales data for any of the items which has been change/update.

Is it possible if we can get notification for successful update or change of items for monthly file.

Thanks,

Rohit

[tajmohamed30]

Please have a look at the incremental load concept in the below link,

Incremental Load Script

[#3]

Hi Taj,

I am having idea on incremental load. But not sure how i can get to know about the record has been updated successfully.

Thanks,

Rohit

[tajmohamed30]

CREATING AUTOMATED ALERTS AND EMAILS SENDING BASED ON DATA LOADED IN QLIKVIEW.docx

[#5]

Thanks Taj for the doc. I have already set an alert for daily data.

But my question is how i come to know the monthy data in QVD has been updated successfully.

Thanks in advance!!

Rohit

[tajmohamed30]

create new app load the qvd and create text object with =reloadtime() function, if you have your last DB update column you can use max of that eg max(DB_Last_Update_Date)

[avinashelite]

You want a double check ?

then try like this once the data is saved to have QVD , load the QVD in another qvw and check for the exists of the records using Exists() function and the excel you have received for to  update ...

Hope helps you to achieve your requirement