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

Selecting All previous months using Button

Hi,

I am trying to select all months but current in listbox using a Button. I am using two "select in field" actions. One for year where I am selecting the max year. The second one is to select all the previous months.

I am using the below code but getting nowhere.

 ='<=$(=month(Addmonths(Today(),-1)))'

 Tried a couple of things but nothing seems to be working.

The field I selected has a list of months and the below code(script):

Dual(Month(MakeDate(----

Labels (2)
2 Replies
MayilVahanan

Hi 

Try like below

MayilVahanan_0-1633656219748.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
AB108
Contributor III
Contributor III
Author

Hi,

Thanks this worked. Just one problem, now in my current selection pane the Month is appearing as "<=9" instead of "<=Sep". 

Can this be changed.