Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help

Hi. I have two listbox that consist of two calendars month. What Im trying to achieve is something like this.

Name              Jan - Feb               Mar - May

                      x          y               x          y

Ryan               2         3               3           2

Joey                3         2               2           3

Listbox1: Selected Jan-Feb

Listbox2: Selected Feb-May

Please help me. Thanks

13 Replies
Not applicable
Author

Hi. Thanks for the effort. But its not something that I want to achieve. Please take a look on the excel file. That's exactly I want to achieve. Hope you get what I mean.

sample.jpg

shreyashetty_ge
Contributor II
Contributor II

hi...well do you need to show the selected fields in the label of the expression ?

If so then try using this ..

getfieldselections (MonthAndYear2,'-')

Alejandro_Hernández
Former Employee
Former Employee

as close as I can get to what you want without complicating it too much.

Untitled.jpg

Not applicable
Author

Thanks. Im getting near, how should i modify that when I select on Calendar1, Calendar 2 should not select what I selected on calendar 1. Thanks