Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need Min Year and Min Month value

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.

aa.jpg


v.jpg

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

0 Replies