Conditional scripting to select one of many fields in a data set

Mon, 18 Feb 2013 22:49:04 GMT

Hello,

The attached string of data is a number of different progress updates for a single sample query (called number 12345). I am trying write script that provides a couple of different outputs:

(1) There are multiple "scheduling dates" - I need to create a master ScheduleDate that just pulls the timestamp for the very first "Update" in time that is "Scheduled."

(2) Generate a list that includes this query number 12345 when the "Update" field has changed from anything other than "Unable to Contact" to "Unable to Contact" (e.g. a list generated on both 28-Jun-12 and 17-Jul-12 would include this query number, but not on 01-Jul-12 because the "Update" field is the same.

Thanks for the help!

Number	Update	Update Timestamp	Status Timestamp
12345	Dispatched	28-Jun-12	28-Jun-12
12345	Unable to Contact	28-Jun-12	28-Jun-12
12345	Unable to Contact	01-Jul-12	01-Jul-12
12345	Scheduled	03-Jul-12	05-Jul-12
12345	In Progress	05-Jul-12	05-Jul-12
12345	In Progress	05-Jul-12	05-Jul-12
12345	In Progress	05-Jul-12	05-Jul-12
12345	Unable to Contact	10-Jul-12	10-Jul-12
12345	Scheduled	12-Jul-12	13-Jul-12
12345	Scheduled	12-Jul-12	10-Jul-12
12345	In Progress	13-Jul-12	13-Jul-12
12345	Unable to Contact	17-Jul-12	17-Jul-12
12345	Unable to Contact	10-Aug-12	10-Aug-12
12345	Complete	12-Aug-12	12-Aug-12

topic Conditional scripting to select one of many fields in a data set in QlikView

Conditional scripting to select one of many fields in a data set