Expression/Script required

Fri, 10 Aug 2012 07:05:20 GMT

Hi,

In the below table, Show field need to be calculated as expression or during scripting.

1) For category if there is a first initial date exists and there is no Actual date, status of that record need to be shown in Show Column.
2) If both initial date and actual date exist then status of next record to be shown in Show column.

3) If all status has initial and actual date then Show column should show 'Complete'

Category	Status	Initial	Actual	Show
C1	A	16-01-2012		A
C1	B
C1	C

C2	A	18-08-2011	18-08-2011	B
C2	B	05-12-2012
C2	C	11-07-2013

C3	A	16-12-2010	16-12-2010	C
C3	B	16-12-2010	16-12-2010
C3	C	26-04-2012

C4	A	11-08-2011	11-08-2011	Complete
C4	B	01-06-2012	05-06-2012
C4	C	26-07-2012	26-07-2012

Please find the sample attached file.

Thanks,

topic Expression/Script required in QlikView

Expression/Script required