Count of id's,Comparison between two dates based on the target date change

[srinivasuluraju]

Hi all,

I  need your help because i'm facing this issue in qlik.i  want count of ids based on the comprasion between two dates if target date should be chage(I want target date change of id's count in sctipt level).I wanted to this in sctipt side.

Ex data:

Date	Id	Target date
01-04-2018	1	04-05-2018
03-04-2018	1	05-05-2018
04-04-2018	2	06-05-2018
05-04-2018	2	06-05-2018

o/p:

From above table I wanted outpit is "Id1" count only.because it has target date chage based on comparison of date field.id2 is not required output.

Thanks in advance !

[neelamsaroha157]

Can you explain a bit more about the logic? I see that all the Target dates have changed when compared to the Date field.

[srinivasuluraju]

Thanks for your response.

If we see the above table,Id is 1 and id 1target date change from 04-05-2018 to 05- 05-2018, if I compared 01-04-2018 and 03-04-2018 dates the  required output is id 1.while comparison b\w two date we have to count  of id's if target date change,if target date has not any change while comparison it is not required.

[neelamsaroha157]

Check this out.

[srinivasuluraju]

Hi Neelam, I lose which one you shared to me. could you please share that document.it should be helpful to me.

[neelamsaroha157]

Here you go  -

[srinivasuluraju]

Thanks for shared that, but it's not working properly.

my requirement is, we split date field as two filters like "From Date' and " To date". then user should select one value from "From Date" and one value from "To date". while we have to calculated Count of ids based on this condition "Target date should change" between two selected dates then only we calculate count of ids otherwise not required.

Thanks in Advanced !