topic Date Range in Set Analysis in QlikView

Date Range in Set Analysis

Fri, 20 May 2011 18:27:50 GMT

Need to be able to expand the date range. How do you do a between clause. I would like to make it a 3 month sum

sum({ $<Forecast_CloseDate={[05-2011]}, Forecast_Probability ={'>70<100'}>} ForecastOppAmount)

Thanx

Fri, 20 May 2011 19:15:03 GMT

You would handle it just like you handled your Forecast_Probability range:

sum({ $<Forecast_CloseDate={'>05-2011<08-2011'}, 
 Forecast_Probability ={'>70<100'}>} ForecastOppAmount)

Keep an eye on those date formats though. If your format doesn't match up correctly, the expression would probably return null.

Fri, 20 May 2011 19:16:36 GMT

totally worked. Thank you!