topic find next date in QlikView

find next date

Mon, 14 May 2012 07:37:54 GMT

Hi all,

i a number of records, each record has a date value in the field "Date".

How can i find the one record that has the first date after today's date or today's date if there is a record that has today's date in the field "Date".

I have tried FirstSortedValue() but this does not seem to give me the right result. It seems to return always the first date within all records - ignoring todays date.

Thanks a lot!

find next date

deepakk — Mon, 14 May 2012 08:29:59 GMT

Hi,

Can you attach some sample datain excel and provide the output that is required.

Deepak

Re: find next date

Mon, 14 May 2012 08:39:46 GMT

Thanks for your reply, lets take the following sample data:

Event	StartDate
Event_A	2011-12-23
Event_B	2012-05-10
Event_C	2012-05-16
Event_D	2012-06-02
Event_E	2012-06-15

In a text field i want to display: Next event:YYYY-MM-DD

Means: Today it would say: Next event: 2012-05-16...

on e.g. the 22nd of May it should display: Next event 2012-06-02

Hope this illustrates the problem better.

Thanks a lot!

Re: find next date

deepakk — Mon, 14 May 2012 09:01:01 GMT

Hi,

Try the attach application.

Deepak

find next date

Mon, 14 May 2012 09:12:32 GMT

Thanks, but sorry, this is does not work for me.

I need to know for today's date, what is the next event. And i need to display this in a text box. Not sure, how i would do this with your example ...

Re: find next date

deepakk — Mon, 14 May 2012 09:42:06 GMT

Hi,

Try this application. You can also you a calendar instead of today to make it dynamic.

Deepak

find next date

Tue, 15 May 2012 09:44:23 GMT

Thanks. This worked.