
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to detect changes in two excel files using QlikSense?
Hi I have to generate daily report to compare
Two files:
Yesterday file:
Srno, WorkerName, Role, StartDate, EndDate
1, XYZ, TESTER, 1/27/2023, 11/28/2023
2, ABC, QA, 11/1/2023, 11/28/2023
Today file
Srno, WorkerName, Role, StartDate, EndDate
1, XYZ, QA, 11/28/2023, NA
2, CDE, DEV, 10/1/2023, 10/28/2023
EXPECTED SCENARIO:
Role changed: XYZ--> from TESTER to QA
- Subscribe by Topic:
-
Data Load Editor
-
Developers
-
General Question
-
Script
-
Visualization
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello
You need to have the file store in daily basis to be able to analyze the difference in first place.
One you have this, you load the Data form yesterday + today, sort the data by ID
and check each field if has change for example
If( Previous(Srno) = Srno,
If(Previous(Worker) <> Worker Or
If(Previous(Name) <> Name Or
If(Previous(Role) <> Role Or
If(Previous(StartDate) <> StartDate Or
If(Previous(EndDate) <> EndDate , 1 , 0 ) ))) As [ Check data changed]
Then you can store only the changed rows in one Qvd in incremental load and analyze what was changed

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello
You need to have the file store in daily basis to be able to analyze the difference in first place.
One you have this, you load the Data form yesterday + today, sort the data by ID
and check each field if has change for example
If( Previous(Srno) = Srno,
If(Previous(Worker) <> Worker Or
If(Previous(Name) <> Name Or
If(Previous(Role) <> Role Or
If(Previous(StartDate) <> StartDate Or
If(Previous(EndDate) <> EndDate , 1 , 0 ) ))) As [ Check data changed]
Then you can store only the changed rows in one Qvd in incremental load and analyze what was changed

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much for your quick response and for providing solution. I really appreciate it 🙂

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Np anytime 😄
