Need Min Year and Min Month value

Tue, 15 Jul 2014 08:19:00 GMT

Hello,

I have 2 List box Year & Month.

When user clicks on multiple months it gives me minimum month (April's Open count) perfectly.

But when user selects mutiple YEARS from the listbox its not working for other Years.

When user selects mutiple years ,I want minimum year's count as April month of both the Years. Set Analysis as below.

Set Analysis:

= if

(

GetCurrentField("Year-Month") = 'MONTHS',Sum ( OPEN_COUNT)

,if(GetCurrentField("Year-Month") = 'YEARQTR' ,Sum({<[MONTH_FORSELECTION] = {'JAN','APR','JUL','OCT'}>} OPEN_COUNT)

//, if(GetCurrentField("Year-Month") = 'YEARS',Sum({<[MONTH_FORSELECTION] = {'APR'}>} OPEN_COUNT))

, if(GetCurrentField("Year-Month") = 'YEARS',Sum({<YEARMONTHDATE = {'$(=MIN(YEARMONTHDATE))'}>} OPEN_COUNT))

)

Thanks in advance.

Bhavesh

topic Need Min Year and Min Month value in QlikView