Discussion board where members can learn more about Qlik Sense App Development and Usage.
I dont have updated date along with changed status,How to capture the updated status changed date please let us know the suggestions on this.please find the data
Current data with updated status
Actually i don't have updated status date column in source database here but user want to check the aging of the different status changes,how to capture the updated date along with changed status
If my understanding is correct, you are trying something like slowly changing Dimension concept.
In this case, use Incremental load using QVD with insert only and maintain an addition 2 column for all the data source table(Incase source system not maintaining).
1. Reload date (DateTime, incase multiple load on same day) -> This will keep track of all record getting loaded
2. Active Record -> To select latest records for unique business column value