topic Re: Quick question on alert email set for successful update in QlikView

Quick question on alert email set for successful update

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Quick question on alert email set for successful update

tajmohamed30 — Wed, 14 Jun 2017 15:11:14 GMT

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

Incremental Load Script

Re: Quick question on alert email set for successful update

Wed, 14 Jun 2017 19:15:58 GMT

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

Re: Quick question on alert email set for successful update

tajmohamed30 — Thu, 15 Jun 2017 12:31:49 GMT

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

Re: Quick question on alert email set for successful update

Thu, 15 Jun 2017 13:48:19 GMT

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

Re: Quick question on alert email set for successful update

tajmohamed30 — Thu, 15 Jun 2017 14:08:34 GMT

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)

Re: Quick question on alert email set for successful update

avinashelite — Thu, 15 Jun 2017 14:18:03 GMT

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