Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

When New Data has been added any given Time.

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

8 Replies
suresh_rawat
Creator II
Creator II

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

suresh_rawat
Creator II
Creator II

- 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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

nilesh_gangurde
Partner - Specialist
Partner - Specialist

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       

Not applicable
Author

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

suresh_rawat
Creator II
Creator II

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