topic Re: Get result by first immidiate less date from another table in QlikView

Get result by first immidiate less date from another table

Thu, 11 Jul 2013 08:22:25 GMT

Hello Friends,

Here i have two tables.

In Table A, there are some part no. with different created date and task no.

In Table B, there are some part no. with different ID no. and ID_Date.

Now

Example 1:

In Table A, Task No. 1, Part No. A and Created Date: 08/07/2013 10:27:03

Now i want to get ID No from Table B according to part no. and created date.

Task No. 1, Part No. A and Created date: 08/07/2013 10:27:03, So for same part no. immidiate first less date of created date in Table B is 08/07/2013 10:20:00

So ID No is ID_1

Example : 2

Task No. 3, Part No. A and Created date: 08/07/2013 12:27:03, So for same part no. immidiate first less Id_date of created date in Table B is 08/07/2013 10:30:00

So ID No is ID_2

Example : 2

Task No. 4, Part No. C and Created date: 08/07/2013 13:07:00, So for same part no. immidiate first less Id_date of created date in Table B is 08/07/2013 11:30:00

So ID No is ID_5

TABLE: A

TASK NO.	CREATED BY	PART_NO	CREATED DATE
1	AAA	A	08/07/2013 10:27:03
2	AAA	B	08/07/2013 11:00:00
3	AAA	A	08/07/2013 12:27:03
4	BBB	C	08/07/2013 13:07:00
5	CCC	B	08/07/2013 14:20:03

TABLE: B

PART_NO	ID	ID_DATE
A	ID_1	08/07/2013 10:20:00
A	ID_2	08/07/2013 10:30:00
B	ID_3	08/07/2013 11:30:00
B	ID_4	08/07/2013 12:00:00
C	ID_5	08/07/2013 11:30:00

Please let me know how do i achive this result?

Thanks

Re: Get result by first immidiate less date from another table

Thu, 11 Jul 2013 08:33:49 GMT

Try the Interval function.

Re: Get result by first immidiate less date from another table

Gysbert_Wassenaar — Thu, 11 Jul 2013 14:45:11 GMT

See attached qvw.

Re: Get result by first immidiate less date from another table

Thu, 11 Jul 2013 14:47:36 GMT

Hi Gysbert,

I have a qvw file scheduled based on another qvw filw succeded the reload ifs fine in the physical folder but the task status is still showing running and it is showing Abort Reload button enable it doesn't go to grey but the other tasks are fine Could you help me what is the problem

Re: Get result by first immidiate less date from another table

Mon, 15 Jul 2013 16:10:02 GMT

This sounds like the old server bug, you will need to restart the services and probably update to a new SR