How to data from date

[Anonymous]

Hi there,

We have a QVW of contracts.  I want to use the start_date field and choose one date and have it show me everything from that date.

I will also need the ability to choose another field as well.

Is there a set analysis that will do this?  I thought some sort of greater then one.

I'm super stuck and have searched everywhere.

I don't have the ability to add a calendar to this one.  Just using the start_date field.

Thanks!

[maxgro · Accepted solution]

script for test data

load

  'contract ' & rowno() as contract,

  date(makedate(2016) + floor(rand()*365)) as start_date

AutoGenerate 1000;

the expression in chart is

Only({$ <start_date={">=$(=max(start_date))"}>} start_date)

[jolivares]

I trying to figure out what you are saying but really I can see it.  I suggest that is better to post an example of what you want so I can help you

[Anonymous]

Thanks for your help.

Here is a sample data set:

contract_id	start_date	funds
5678	18/12/2013	UNL
5679	20/12/2013	UNL
5680	22/12/2013	UNL
5681	23/12/2013	UNL
5682	28/12/2013	UNL
5683	31/12/2013	UNL
5684	01/01/2014	UNL
5685	04/01/2014	88
5686	07/01/2014	23
5687	08/01/2015	UNL
5688	19/01/2015	UNL
5689	23/01/2016	75
5690	27/01/2016	12

So I would want to show all contracts from 01/01/2014 with UNL.

If I choose the start_date of just 01/01/2014, then I only get contract 5684.  I want that date and everything past that date to show. 

I should get this:

contract_id	start_date	funds
5684	01/01/2014	UNL
5687	08/01/2015	UNL
5688	19/01/2015	UNL

I hope this helps better.

Thanks!

[Anonymous]

Whoa I think this is it.

Thanks a lot!