Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
d_koti24
Creator II
Creator II

regarding excluded values

Hi All,

Hi I have one requirement,I have one table that table contains sales data country and cities wise like this

1.PNG

If i select one city in filters automatically filter the data based on the filter.suppose if i select city Canberra i am getting data like this.

2.PNG

No issues on that,if select any excluded city ,automatically clear the data,and filter based on selection. lie this

3.png

if i select Washington,D.C. filter the data based on city like this

4.PNG

But My requirement is if i select any excluded value in multibox ,i want to add that selected data to the existing data in straight table,  like this:

5.png

6.png

How to achive this?

how to select the excluded value in multibox?with out clearing old data?

Help me on this..

Regards,

kd

8 Replies
swuehl
MVP
MVP

Have you tried pressing the CTRL key while selecting the new value?

d_koti24
Creator II
Creator II
Author

By Using CTRL it's working ,but i want with out using CTRL.

Is there any possible?

swuehl
MVP
MVP

In a list box, you can select e.g. the Windows checkboxes style.

In a multibox, I don't think you can select a different style, so this might be no option.

Anonymous
Not applicable

tif you use LED checkbxoes as your listbox style ou donot Need to hold the CTRL key, but select individually

but that's a different style of listbox, not everybody likes that

gautik92
Specialist III
Specialist III

you can select using ctrl key

Not applicable

Hey, In Mutibox you can select using CTRL key, but if you have multiple values to select then go to Table, enable Drop down select and in drop down field do search and paste (Canberra|Washington, D. C.|....) .  

d_koti24
Creator II
Creator II
Author

This is sample data,but in my app 12 filters are there in multibox...so is there any possible to do this in multibox?

jonathandienst
Partner - Champion III
Partner - Champion III

koti d wrote:

By Using CTRL it's working ,but i want with out using CTRL.

Is there any possible?

Why? That is the standard Windows way of doing things... Ctrl-Select adds to a selection

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein