Compare two dates check the Status change

rajinikanth — Wed, 25 Nov 2020 16:16:04 GMT

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.

ID	DATE_UNIT	Target_Date
I-00043959	3/Apr/2018	31/Jul/2018
I-00043959	1/May/2018	31/Jul/2018
I-00043959	1/Jun/2018	31/Aug/2018
I-00043959	2/Jul/2018	31/Aug/2018

Re: Compare two dates check the Status change

vishsaggi — Wed, 29 Aug 2018 18:08:48 GMT

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.

Re: Compare two dates check the Status change

MK9885 — Wed, 29 Aug 2018 19:17:30 GMT

Where is your Closed Date field?

topic Re: Compare two dates check the Status change in QlikView

Compare two dates check the Status change

Re: Compare two dates check the Status change

Re: Compare two dates check the Status change