topic Re: Select Next Ten Dates in QlikView

Select Next Ten Dates

evansabres — Fri, 21 Sep 2018 19:43:27 GMT

I have a field Event_Date.

I have a table that I only want to display the next 10 Event_Date's relative to today's date. How can I edit my dimension to reflect this?

Re: Select Next Ten Dates

vishsaggi — Fri, 21 Sep 2018 20:07:14 GMT

May be try like below make sure you have same format for your eventdate and Today() date.

Sorry count does not work try Rank

= Aggr(IF(Count(If(Event_Date > Today(), EventDate))<11, Event_Date), Event_Date)

= Aggr(IF(Rank(IF(Event_Date>Today(), Event_Date))<=10,Event_Date), Event_Date)

Re: Select Next Ten Dates

evansabres — Fri, 21 Sep 2018 20:17:07 GMT

Unfortunately, this did not produce the desired result.

Re: Select Next Ten Dates

evansabres — Fri, 21 Sep 2018 20:21:22 GMT

Rank worked perfectly

Re: Select Next Ten Dates

evansabres — Fri, 21 Sep 2018 20:24:44 GMT

Actually, this output generated the 10 final dates as opposed to the next ten

Re: Select Next Ten Dates

vishsaggi — Fri, 21 Sep 2018 20:25:59 GMT

Did not get you. The next ten event dates are greater than today right?

Re: Select Next Ten Dates

evansabres — Fri, 21 Sep 2018 20:27:31 GMT

If I flip to = Aggr(IF(Rank(IF(Event_Date>Today(), Event_Date))>=10,Event_Date), Event_Date) and then restrict to the first 10 values in the dimension limits tab works

Re: Select Next Ten Dates

vishsaggi — Fri, 21 Sep 2018 20:31:59 GMT

NOt sure when you say next ten dates. Rank(IF(Event_Date > Today(), Event_Date)) Will rank the EventDates greater than today. So Date1 will be 1, 2, 3, etc. Then you are saying if Rank() of those reaches 10 then show those dates. Why do you need >=10?