Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Select automatically more values if one value has selected in list box!

I have a list box with month values! Jan, Feb, Mar, Apr,May, Jun,......., Dec

I want if i choose month May for example, the month Jan till May automatically be selected in listbox(highlighted green)!

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Select automatically more values if one value has selected in list box!

Sure.  Your Month field must be dual, to support this.

In Document Properties - Triggers, create trigger on Field Month.  The action on select will be

Select in Field

Field

Month

Search string

= '<=' & num(Month)

5 Replies
mov
Esteemed Contributor III

Re: Select automatically more values if one value has selected in list box!

Sure.  Your Month field must be dual, to support this.

In Document Properties - Triggers, create trigger on Field Month.  The action on select will be

Select in Field

Field

Month

Search string

= '<=' & num(Month)

Not applicable

Re: Select automatically more values if one value has selected in list box!

You can definitely achieve this using Michael's suggestion above, however I would be wary of implementing it without being completely sure that is what you want.  Sometimes auto-selections can confuse and frustrate users and take away from the built-in functionality of QlikView.

mov
Esteemed Contributor III

Re: Select automatically more values if one value has selected in list box!

Yes Rebecca Camper, as a user I'd be confused if I make a selection and it is overridden right away.

Be careful what you wish for...

Not applicable

Re: Select automatically more values if one value has selected in list box!

Thanks Michael. That is works great!

Not applicable

Re: Select automatically more values if one value has selected in list box!

Thank you Rebecca for your comment. I want to use month listbox with automatic selection only in tab with YTD vs LY YTD and that is very clear to users!

Community Browser