topic Re: How to data from date in QlikView

How to data from date

Anonymous — Tue, 01 Mar 2016 19:12:32 GMT

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 — Tue, 01 Mar 2016 19:34:21 GMT

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 — Tue, 01 Mar 2016 19:34:51 GMT

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 — Tue, 01 Mar 2016 19:49:17 GMT

Thanks for your help.

Here is a sample data set:

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:

I hope this helps better.

Thanks!

Anonymous — Tue, 01 Mar 2016 19:54:29 GMT

Whoa I think this is it.

Thanks a lot!