topic Re: Selecting All previous months using Button in QlikView

Selecting All previous months using Button

AB108 — Thu, 07 Oct 2021 21:52:31 GMT

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(----

Re: Selecting All previous months using Button

MayilVahanan — Fri, 08 Oct 2021 01:23:56 GMT

Try like below

Re: Selecting All previous months using Button

AB108 — Fri, 08 Oct 2021 19:29:48 GMT

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.