- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)!
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Michael. That is works great!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!