Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Make subset of field based on selection

Hi QV community,

I have a field called "Names" of which I would like to be able to make a subset (new list box) based on current selection.

An example:

I select 10 people out of the "Names" list box, who I would like to look at. All the excluded become grey.

Now I would like to be able to pull this data into a new listbox, I. E. a subset. This should show only the 10 selected.

By doing this I would be able to select a random amount of people in the field, and only focus on them from then on.

This would help, as when showing the application to my manager, I can preselect the 10 names that are important and spare him for the unnecessary information of all the others. This could of course be done by narrowing down the names through other filters (Names starting with A, People in a specific department etc.), but this does not give the same amount of flexibility as I would like all other filters to stay open for my manager to use for his further selections as well as avoiding too many "grey excluded" to confuse (I do not want to hide these, as it should be easy to switch between the 10 names).


I hope that this makes sense. Thanks in advance,


Andreas 

1 Solution

Accepted Solutions
srchilukoori
Specialist
Specialist

Please refer to the attached application for a work around.

I have used Hide excluded and Override locked field on the NAME listbox.

View solution in original post

4 Replies
srchilukoori
Specialist
Specialist

Please refer to the attached application for a work around.

I have used Hide excluded and Override locked field on the NAME listbox.

Not applicable
Author

Hi Srchilukoori,

I think that your idea of using Hide excluded and Override locked field on the name listbox sounds like the solution. I have problems getting it to work fully (I am sure that it is just me). On what basis have you created the Name listbox? To me it does not see to be able to select within the names listbox.

Am I oversee something important?

- Andreas

srchilukoori
Specialist
Specialist

The NAME field is a copy of the Name, I just used 'Name as NAME' in the load script.

Not applicable
Author

Okay, thanks.

I think this is the closest to the original thought I have yet to come across. Thanks a lot! Your solution gives me the option (though, as said, as a workaround that is not as handy as could be)

I will mark this as the right answer as this could help others too.