topic Re: How to calculate the intersection between two date columns in QlikView

How to calculate the intersection between two date columns

uacg0009 — Mon, 13 Jan 2014 10:06:32 GMT

Hi all,

I want to calculate the intersection between two date columns,the data like below:

the two date columns are a group by ID_1 and ID_2, what I want is:

Firstly, the different group do not be considered.

And then if in some group, there is intersection between two rows like row 1 and row 2 or row 4 and row 5,

then output String "Warning" in all rows of this group in WARNING column.

the result what I want is:

the in row 3 and WARNING column is "Warning" because row 4 and row 5, not row 1 and row 2.

Finally, is there any possible to make it in expression? or only in script? whatever, I want to know how to make it.

I hope I have clarified what I want, thank you all!

vikasmahajan — Mon, 13 Jan 2014 10:43:40 GMT

I think you should apply interval match fucntion pls refer following link.

Vikas

Anonymous — Mon, 13 Jan 2014 11:00:59 GMT

Hi Changjun,

can you please explain row 3,4 and 5 are coming warning,i didn't get you can you please explain.

Thanks SHAIK

uacg0009 — Tue, 14 Jan 2014 01:59:56 GMT

Because if there is a intersection in a group, all rows of the WARNING column of this group will change to "Warning".

Between

2013-04-01 to 2013-04-20 and

2013-04-10 to 2013-05-10

, there is 10 days overlapped, so it is a intersection.

Thank you basha, I hope I have clarified what you want.

uacg0009 — Tue, 14 Jan 2014 02:18:41 GMT

Thank you Mahajan.

I've already read the doc about interval match function.

And can it use in expression and even in script I also don't know how to use it in my job, because I don't have a column

like Marks to match. Do you have any ideas?

Nicole-Smith — Tue, 14 Jan 2014 16:55:03 GMT

Have a look at the load script in the attached. I think it should give you what you need.