Help with this please!

Wed, 18 Jul 2012 00:54:03 GMT

Hi all,

Solution statements:

Only for those records with topmost condition 08.* and the second condition counting from the top is 07.*,we need to identify the following 2 dates of change of condition: -corresponding date of topmost condition if 08.*, and; -corresponding date of condition 07.1

Record with ID A does not qualify as even thou its topmost condition is 08.2 (08.*), its second condition from the top is 08.1 (not 07.*)

Record with ID B does qualify as its topmost condition is 08.1 (08.*) and its second condition from the top is 07.2 (07.*); for this record we need to find the dates that correspond to condition 08.1 and 07.1 specifically (not 07.2)

Record with ID C does not qualify as, even thou its topmost condition is 08.2 (08.*), its second condition from the top is 08.1 (not 07.*)

Record with ID D does not qualify because its topmost condition is not 08.*

Record with ID E does qualify as its topmost condition is 08.1 (08.*) and its second condition from the top is 07.1 (07.*); for this record we need to find the dates that correspond to condition 08.1 and 07.1

ID	Condition	Date of condition change
A	08.2	F1
A	08.1	F2
A	07.3	F3
A	07.2	F4
A	07.1	F5
A	06.1	F6
A	05.1	F7
B	08.1	F8
B	07.2	F9
B	07.1	F10
B	06.1	F11
B	05.1	F12
C	08.2	F13
C	08.1	F14
C	07.1	F15
C	06.1	F16
C	05.1	F17
D	07.3	F18
D	07.2	F19
D	07.1	F20
D	06.1	F21
E	08.1	F22
E	07.1	F23

Expected Selections

ID	Date 1	Date 2	Result (substraction)
B	F8	F10	F8-F10
E	F22	F23	F22-F23

Thanks,

Fernando Obando

topic Help with this please! in QlikView

Help with this please!