Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
gopinadhpindra
New Contributor II

How to capture changed status along with date

Dear Team,

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 

Yesterday data:

Date Statusnum
1/1/2019Inprogress1
1/2/2019Inprogress2
1/3/2019Inprogress3
1/4/2019Inprogress4
1/5/2019pending5
1/6/2019pending6
1/7/2019pending7
1/8/2019pending8
1/9/2019Closed 9
1/10/2019Closed 10
1/10/2019Closed 11

 

Current data with updated status

Date Statusnum
1/1/2019pending1
1/2/2019pending2
1/3/2019pending3
1/4/2019In progress4
1/5/2019Closed 5
1/6/2019Closed 6
1/7/2019pending7
1/8/2019pending8
1/9/2019Closed 9
1/10/2019Closed 10
1/11/2019Closed 11
1/11/2019Inprogress12
1/11/2019Inprogress13

 

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

 

Thanks

 

 

 

Tags (2)
2 Replies
zzyjordan
Contributor II

Re: How to capture changed status along with date

Hi,
What's your expected result? e.g. along the rows, 1/4/2019, 1/5/2019, 1/7/2019,1/9/2019,1/11/2019 should be captured as these days there is a status change comparing to previous?
ZZ
anilmahanty
New Contributor III

Re: How to capture changed status along with date

Hi,

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

IDAmtReloadActive Status
11001/10/20190
21501/10/20190
32001/10/20191
42201/10/20191
11101/11/20191
2801/11/20191
Community Browser