Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)!
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)
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)
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.
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...
Thanks Michael. That is works great!
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!