Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Help with this please!

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

IDConditionDate of condition change
A08.2F1
A08.1F2
A07.3F3
A07.2F4
A07.1F5
A06.1F6
A05.1F7
B08.1F8
B07.2F9
B07.1F10
B06.1F11
B05.1F12
C08.2F13
C08.1F14
C07.1F15
C06.1F16
C05.1F17
D07.3F18
D07.2F19
D07.1F20
D06.1F21
E08.1F22
E07.1F23

Expected Selections

IDDate 1Date 2Result (substraction)
BF8F10F8-F10
EF22F23F22-F23

Thanks,

Fernando Obando

Community Browser