topic Re: Select multiple months in a field in QlikView

Select multiple months in a field

danosoft — Thu, 16 Apr 2020 09:50:16 GMT

I have a field with the months like you see in the picture

I want when clik to the my sheet, automatically select all month previous to the current date (and the actual month too)

Example:

Now i want to select month 01,02,03,04

thanks

rubenmarin — Thu, 16 Apr 2020 11:04:35 GMT

Hi, you can try with triggers. In document properties -> triggers -> Field events -> select month field name -> add On select action.

Add a new Select on field action filling Name with the field name and Value With ='<=' &Max(MonthFieldName)

danosoft — Fri, 17 Apr 2020 07:12:11 GMT

Hi, thanks you , but as you see, when i come inside my sheet it selected all months, not only

01,02,03,04

like i expect

rubenmarin — Fri, 17 Apr 2020 07:14:52 GMT

Hi, sorry I read it too fast, i thought you wanted to select all months previous to the one clicked.

To select all months previous or equal to current month you can use: ='<=' &Num(Month(Today()))