topic Re: Find Min & max Date and show Null in QlikView

Find Min & max Date and show Null

Tue, 20 Jan 2015 12:38:03 GMT

Hi All,

I need the expression for a new field.

if event date is min show only the forecast date which is >event date

if event date is max show only the forecast date which is <event date. and make other dates as Null

Thankyou

Vam

terezagr — Tue, 20 Jan 2015 12:43:11 GMT

Try this:

if (min(event_date)>event_date, forecast_date,

if(max(event_date)<event_date,forecast_date, '0'))

Regards,

Tue, 20 Jan 2015 13:56:22 GMT

No Tereza its not working..