Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
srini
Creator
Creator

Adding and showing new month data without affecting the current data!

Hi All,

Very good Day!

I have a scenario like this... I have prepared the dash board with current month data, the source I have extracted from x source(excel file). Next month I need generate the same dashboard from the same source it is a monthly work. But when I add data for next month it should not replace the current month data... I need that should be added as new i.e in the app March data also should be visible and April data should be visible. the worst part here is the data doesn't contain any date field. I am struck her... can you please help on this?

 


thanks & Regards,

Srini

2 Replies
vikasmahajan

Hi Srini,
In this case you need to store all the data into QVD and apply the incremental load concept for new data addition. Refer the link given below :
https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

HTH

Vikas
Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
srini
Creator
Creator
Author

Thanks Vikas! 🙂