topic Re: Multiple field value select in macro in QlikView

Multiple field value select in macro

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a listbox containing "CalendarDate". I want to add a button that uses a macro that allows the user to select a date in the listbox, and then click the button to also select the 11 prior dates in the listbox. So, if the user selects "5/1/2016", and then clicks the button, the 11 preceding dates in the listbox will also be selected.

How do I accomplish this?

Re: Multiple field value select in macro

Wed, 10 Aug 2016 15:52:28 GMT

Hey John,

Are those date consecutive? Or there may be some gaps (missing dates) in the listbox?

BR,

Kuba

Re: Multiple field value select in macro

Anonymous — Wed, 10 Aug 2016 16:03:31 GMT

They're assumed to be consecutive (each date represents the 1st day of each month). The list is sorted in descending order with the most recent date being displayed first.

Re: Multiple field value select in macro

Wed, 10 Aug 2016 17:01:44 GMT

Hello John,

Please see attached app.

Considering the field is named "Date", I have created a button and added "Select in Field" Action into it:

Field:

Date

Expression:

='>'&Date([Date]-12)&'<='&Date([Date])

PS Button is active only if 1 value is selected in Date listbox.

BR,

Kuba

Re: Multiple field value select in macro

Anonymous — Wed, 10 Aug 2016 17:14:04 GMT

I had to make a change, given that the dates are always the first of the month, but in general, it worked:

='>'&AddMonths(Date([CalendarDate]),-11)&'<='&Date([CalendarDate])

Many thanks.

Re: Multiple field value select in macro

Wed, 10 Aug 2016 17:48:26 GMT

Hey John,

Glad it worked for you! Please mark question as answered.

BR,

Kuba