topic Set analysis with subset? in QlikView

Set analysis with subset?

Thu, 30 Jun 2011 09:51:46 GMT

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.

Set analysis with subset?

IAMDV — Thu, 30 Jun 2011 10:46:44 GMT

Hi,

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

Cheers - DV

Set analysis with subset?

Thu, 30 Jun 2011 11:09:35 GMT

Hi DV,

Sure I can, see the file above.

Cheers

Re: Set analysis with subset?

IAMDV — Thu, 30 Jun 2011 11:40:07 GMT

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

Re: Set analysis with subset?

IAMDV — Tue, 05 Jul 2011 11:04:23 GMT

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

Re: Set analysis with subset?

Tue, 05 Jul 2011 20:16:18 GMT

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