topic When New Data has been added any given Time. in QlikView

When New Data has been added any given Time.

Mon, 19 Mar 2012 07:25:07 GMT

Dear Friends,

I attach data. I want to know if any given period of time data has been added then how to calculate & show What data has been added.

Any one, Please do the needful.

Regards

Ravi Gupta

When New Data has been added any given Time.

suresh_rawat — Mon, 19 Mar 2012 07:47:09 GMT

Hi Ravi Gupta,

- IF you are adding the data in the exsisting excel sheet then you just need to reload your script again.

- If you create your new database just put your cursor below the closing of the bracket of the previous data you already loaded in the script. Then in the Script just click on the Table

When New Data has been added any given Time.

suresh_rawat — Mon, 19 Mar 2012 07:51:00 GMT

- If you create your new database just put your cursor below the closing of the bracket of the previous data you already loaded in the script. Then in the Script just click on the Table Files then select the file where you created your database.
- Then just save and reload the data in the script.

Hope this will help you.

Thanks & Regards
Suresh Rawat

When New Data has been added any given Time.

Mon, 19 Mar 2012 07:52:06 GMT

Hi Suresh,

Thanks for reply.

But my question is that how to check Previous data Count and New data count. if any row added then how to check that row has been added.

Please understand my Problem.

Regards

Ravi Gupta

When New Data has been added any given Time.

Mon, 19 Mar 2012 07:53:39 GMT

Hi Suresh,

Thanks for reply.

But my question is that how to check Previous data Count and New data count. if any row added then how to check that row has been added.

Please understand my Problem.

Regards

Ravi Gupta

When New Data has been added any given Time.

Mon, 19 Mar 2012 07:55:50 GMT

Hi Suresh,

Thanks for reply.

But my question is that how to check Previous data Count and New data count. if any row added then how to check that row has been added.

Please understand my Problem.

Regards

Ravi Gupta

When New Data has been added any given Time.

nilesh_gangurde — Mon, 19 Mar 2012 07:58:22 GMT

Hi Ravi,

For this purpose put the one date field along with this two fields, and everytime take increamental load by cheking the date in date field.

Regards,

Nilesh Gangurde

When New Data has been added any given Time.

Mon, 19 Mar 2012 08:45:28 GMT

Hi Suresh,

Thanks for reply.

But my question is that how to check Previous data Count and New data count. if any row added then how to check that row has been added.

Please understand my Problem.

Regards

Ravi Gupta

When New Data has been added any given Time.

suresh_rawat — Mon, 19 Mar 2012 08:55:39 GMT

Hi Ravi Gupta,

For that you need to write a expression which include time and date so that after particular date or time you can check the new data you added in your database.

Thanks & Regards
Suresh Rawat