topic Re: List box selection - not affected by "Clear all" in QlikView

List box selection - not affected by "Clear all"

Wed, 12 Mar 2014 10:20:15 GMT

Dear Community,

I have a special condition where I need select "Client Name" by default in list box,

even user clicks "Clear all selection", Client Name will still be selected.

I have my default selection done with Sheet trigger --> add action --> on activate sheet --> select field.

But once I click "Clear all selection", everything will be clear, what can i do to select "Client Name" always be selected?

Thanks,

Chanel

Re: List box selection - not affected by "Clear all"

MK_QSL — Wed, 12 Mar 2014 10:22:11 GMT

Go to your list box.

select Client Name

Now under List Box Properties

select always one selected value

Re: List box selection - not affected by "Clear all"

tresB — Wed, 12 Mar 2014 10:22:35 GMT

Select one value from the list box->Properties->General tab-> Check 'Always One Selected Value'

Re: Re: List box selection - not affected by "Clear all"

Wed, 12 Mar 2014 10:25:57 GMT

Thanks for prompt response!

However, it shows in grey so i can't activate it.

is it because this field is system dimension?

Re: Re: List box selection - not affected by "Clear all"

Wed, 12 Mar 2014 10:27:15 GMT

Thanks for fast response!

As shown in previous reply, i am not able to activate it, not sure is because of system dimension?

Re: List box selection - not affected by "Clear all"

Wed, 12 Mar 2014 10:28:05 GMT

Hi,

Keep one value selected in the list box then only the "Always One Selected Value" option will be enabled. Then go to properties and check "Always One Selected Value".

Re: List box selection - not affected by "Clear all"

jsingh71 — Wed, 12 Mar 2014 10:28:51 GMT

Hi,

Select below option in list box property,this will not clear your selection even you click on clear all also.

Re: List box selection - not affected by "Clear all"

tresB — Wed, 12 Mar 2014 10:29:41 GMT

No, you have to select a value from the list first, and then only you will find it selectable.

Re: List box selection - not affected by "Clear all"

MK_QSL — Wed, 12 Mar 2014 10:29:59 GMT

Go to your list box.

select Client Name

Now under List Box Properties

select always one selected value

Read my previous post... You need to select at least one value first then only this property is available.

Re: Re: List box selection - not affected by "Clear all"

Wed, 12 Mar 2014 10:33:00 GMT

Refer to my attached image in previous post, i have selected one value but it is still not working, in grey color...

so i wonder is it related to system dimension (%_dimensions) ?

Thanks,

Chanel

Re: List box selection - not affected by "Clear all"

tresB — Wed, 12 Mar 2014 10:36:20 GMT

You hace selected in _metrics field, while you have to select in other %_dimension for which you want the behavior, right?

Re: List box selection - not affected by "Clear all"

er_mohit — Wed, 12 Mar 2014 10:43:53 GMT

Firstly select one value in the List Box .

After that in General Tab of List Box check the "Always one Selected Value"

Hope this will help you.

Re: List box selection - not affected by "Clear all"

Wed, 12 Mar 2014 10:49:55 GMT

Hi,

Two things need to be checked :

1. It should not be calculated value just a direct dimension, which in your case seems fine.

2. If you have disabled 'SystemFields' , then need to enable it.

This might help.

Re: List box selection - not affected by "Clear all"

sunilkumarqv — Wed, 12 Mar 2014 11:07:42 GMT

Go to Docment Properties -

//Select Which field you want to

Triggers-Field Event Triggers _

OnSelect Edit Actions Addin acation type -Selcection,in Action -Select in field

Then field your filedname example =%_dimension

Seach string as =ClientName

Re: Re: Re: List box selection - not affected by "Clear all"

sunilkumarqv — Wed, 12 Mar 2014 11:11:15 GMT

Try this and follow previous post

use of Clear Other Fields and select in Field

Re: List box selection - not affected by "Clear all"

Wed, 12 Mar 2014 11:21:14 GMT

First try disabling your trigger that clears all selections upon selecting the client name.

Clear all selections.

Then select just one client name.

The option of "Always one selected value" should be enabled.