topic Re: regarding excluded values in QlikView

regarding excluded values

d_koti24 — Thu, 18 Jun 2015 05:06:29 GMT

Hi All,

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

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.

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

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

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:

How to achive this?

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

Help me on this..

Regards,

Re: regarding excluded values

swuehl — Thu, 18 Jun 2015 11:34:01 GMT

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

Re: regarding excluded values

d_koti24 — Thu, 18 Jun 2015 11:36:19 GMT

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

Is there any possible?

Re: regarding excluded values

swuehl — Thu, 18 Jun 2015 11:41:33 GMT

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.

Re: regarding excluded values

Anonymous — Thu, 18 Jun 2015 11:47:08 GMT

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

Re: regarding excluded values

gautik92 — Thu, 18 Jun 2015 11:51:39 GMT

you can select using ctrl key

Re: regarding excluded values

Thu, 18 Jun 2015 11:56:46 GMT

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.|....) .

Re: regarding excluded values

d_koti24 — Thu, 18 Jun 2015 11:56:49 GMT

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

Re: regarding excluded values

jonathandienst — Thu, 18 Jun 2015 11:57:10 GMT

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