topic Re: How to remove all previous selection on a particular column in QlikView

How to remove all previous selection on a particular column

Mon, 19 May 2014 07:54:42 GMT

Dear all,

We have 3 list boxes (3 back-end columns) and we want only 1 selected value across all three columns. User should not be able to select multiple values in any of the list boxes. We have checked the single value selection option in the list box (for all three list box) but doe to this selection we are not able to clear value in other field(list box)

We tried one backed column instead of three columns and based on flag values created 3 list boxes so that selections are automatically cleared in other list boxes. However this approach has a limitation that we cannot have single value selection..

Please let us know any approach to solve this problem ..

Re: How to remove all previous selection on a particular column

struniger — Mon, 19 May 2014 08:26:43 GMT

Hi Ruchi,

If I understand correctly you want to have only one selected value per three dimensions.

One approach could be to add a field event trigger (Document Properties -> Triggers -> Field Event Triggers), where on selection of Dimension 1 you would clear any selections on dimension 2 and 3.

Not sure if this will work with 'always one selected value' though. But maybe it'll help you on the way.

Best regards

Stefan

Re: How to remove all previous selection on a particular column

Mon, 19 May 2014 09:35:25 GMT

Hi Stefan,

Thanks for your inputs.

The above approach works fine on the application of the Event Trigger but though the list boxes have 'always one selected value' option checked, it does not suffice the requirement.

Regards,

Ruchi

Re: How to remove all previous selection on a particular column

Mon, 19 May 2014 09:39:25 GMT

Hi Ruchi,

In attached file only thing you can't do is you can't have pre-selected value for all three lists at the same time

Because we to clear list 1 when we select list 2 so when we try to pre select value in all three lists at document open event it only get selected third list.

Thanks,

Prakash

Re: How to remove all previous selection on a particular column

Mon, 19 May 2014 10:41:16 GMT

Hi,

=Aggr(Only( {< FIELD = p(FIELD) >}FIELD),FIELD)

Apply this expression in your listbox.Uncheck the Always one selected.

Hope it helps.

Thanks.

Re: How to remove all previous selection on a particular column

Mon, 19 May 2014 11:48:40 GMT

Hi gtripathy,

Thanks for your input. The above response is very helpful.

Can you also help us know if we can pick up the dimension name dynamically. So if we have one selected value (i.e. unique) across 3 list boxes, where we would like to have that particular value as a dimension in our chart.

Let us know if you would require any more details.

Regards,

Ruchi

Re: How to remove all previous selection on a particular column

Mon, 19 May 2014 12:42:21 GMT

Hi Ruchi,

Could you please post a sample app or snapshot for better understanding? There is np at all using the same field as Calculated Dimension in your chart.

Don't hesitate to try something what you feel may work out?

Thanks.

Re: Re: How to remove all previous selection on a particular column

Mon, 19 May 2014 14:10:45 GMT

Hi gtripathy,

As proposed, we have created a sample app.

Kindly look into the same.

Thanks.