Show Next Milestone view

dr_suresh_baabu — Sat, 16 Nov 2024 04:52:23 GMT

Hello All,

I'm working on a requirement to display the next immediate milestone in a chart for all projects.

The following are my challenges that needs to be addressed while displaying the next milestone.

1. My date is field is not sorted at source.

2. The next milestone will not always be the following month. It can be any upcoming month

3. A Project can have one or more milestone for the upcoming month .

In my attached sample data. I need to only show the one highlighted in RED.

Could you please share your thoughts?

Thanks,

Suresh

Re: Show Next Milestone view

chrismarlow — Wed, 02 Jan 2019 16:17:32 GMT

Hi,

Taking the liberty of changing your months into dates & just taking the first 7 rows of your data, you could use the following as an expression (& then hide it);

if(min(TOTAL <Project_ID> {<[Milestone Date]={">=$(=MonthStart(Today()))"}>}[Milestone Date])=[Milestone Date],1,Null())

As below;

You can do this with the dates not being held as dates, it is just a bit fiddly (in my opinion).

Cheers,

Chris.

topic Re: Show Next Milestone view in QlikView

Show Next Milestone view

Re: Show Next Milestone view