Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
rajinikanth
Contributor III
Contributor III

Compare two dates check the Status change

Hi All

I have Data as below, When I select any two dates, I need how many ids has the target date got changed, I was trying with the above approach and unable to achieve.( May be i'm not able to do it).

Can you please suggest the way to do this. I need another Date field as CLOSED DATE for my date range selection.

Say if I select DATE_UNIT = '3/Apr/2018' and CLOSED DATE = '2/Jul/2018' I need count as '1' as the target_date got changed from 31/Jul/2018 to 31/Aug/2018.


Similarly for DATE_UNIT = '1/May/2018' and CLOSED DATE = '1/Jun/2018' I need count as '1' as the target_date got changed from 31/Jul/2018 to 31/Aug/2018.


Same for 1/May/2018 to 2/Jul/2018


For 3/Apr/2018 to 1/May/2018 the count of ID should be '0' as the target date didn't got changed.

   

IDDATE_UNITTarget_Date
I-000439593/Apr/201831/Jul/2018
I-000439591/May/201831/Jul/2018
I-000439591/Jun/201831/Aug/2018
I-000439592/Jul/2018

31/Aug/2018

2 Replies
vishsaggi
Champion III
Champion III

Data is insufficient. Add your CLosedDate and put some more data in your table and upload. How do you know for that DATE_UNIT the target is changed? How would you identify that.

MK9885
Master II
Master II

Where is your Closed Date field?