Set analysis with subset?

[#1]

I am using a table containing various states for each id:

ID, status, status_start_date, status_end_date

Now I want to make a straight table with an expression that shows all ID's with status = a and status_start_date = reporting_date.

This works fine, but I want to add a column (called status_start_date2) that contains the min(status_start_date) of status=b in the same row, like depicted below:

ID	status	status_start_date	status_start_date2
1	a	1-2-2009	4-4-2009
2	a	5-2-2009	6-3-2009

Hopefully you can help me.

Update: I just added the .qvw with (limited) sample data.

[IAMDV]

Hi,

Please can you upload the QV document with sample data? I can work an example for you.

Cheers - DV

[#3]

Hi DV,

Sure I can, see the file above.

Cheers

[IAMDV · Accepted solution]

Hi Mate,

Please see the attachement and let me know if you this is what you need. I had used the variables to get this working and I will explain you in detail if this is right for you.

Cheers - DV

[IAMDV]

Hi Mate,

Have you got chance to check this one? Have you got this working...?

If yes, please mark the post answered or we can go further.

Cheers - DV

[#6]

Not completely what I meant, but your solution works fine and my question is answered sufficiently. Thanks!