topic Re: Set default value in listbox in QlikView

Set default value in listbox

Anonymous — Wed, 22 Jul 2015 07:33:59 GMT

Question,

I am loading a listbox for KPI selections with an expression as following:

=if($Field = 'KPI_FIELD1' or $Field = 'KPI_FIELD2' or $Field = 'KPI_FIELD3' or $Field = 'KPI_FIELD4', $Field, null())

When loading data in a listbox like this I am not able to select "Always One Selected Value" or set the default value via a trigger.

Is there a way to do this also?

Br,

Mario

Re: Set default value in listbox

Wed, 22 Jul 2015 07:39:13 GMT

when you load the data. What does the list box show?

Re: Set default value in listbox

Wed, 22 Jul 2015 07:47:51 GMT

Hi,

If you have KPI_FIELD1, KPI_FIELD2,....so on, in different list boxes, please check the "Always One Selected Value".

Then create the Listbox with expression (one that you put in your question), you should be able to see "Always One Selected Value" then.

Thanks!

Re: Set default value in listbox

Anonymous — Wed, 22 Jul 2015 08:17:14 GMT

The listbox shows:

KPI_FIELD1

KPI_FIELD2

KPI_FIELD3

KPI_FIELD4

Re: Set default value in listbox

Wed, 22 Jul 2015 08:25:56 GMT

Or create a new field in the script and use that for the list box. Then you can select 'Always one selected value' property.

If($Field = 'KPI_FIELD1' or $Field = 'KPI_FIELD2' or $Field = 'KPI_FIELD3' or $Field = 'KPI_FIELD4', $Field, null()) as NewField

Regards,

KKR

Re: Set default value in listbox

Anonymous — Wed, 22 Jul 2015 09:37:34 GMT

Here is an example of what I mean.

Re: Set default value in listbox

Wed, 22 Jul 2015 10:43:05 GMT

One way to achieve this is by creating a clear state.

Select one value from the list box, say KPI_FIELD1

Click the drop down arrow just beside 'Clear' button

Click on 'Set Clear State'

Regards,

KKR

Re: Set default value in listbox

Wed, 22 Jul 2015 10:46:10 GMT

Or create a button with below action

'Select in Field' -> $Field as Field -> Enter any KPI field say KPI_FIELD1 in Search String

Regards,

KKR

Re: Set default value in listbox

Kushal_Chawda — Wed, 22 Jul 2015 10:49:02 GMT

Create a trigger on Activate sheet

Re: Set default value in listbox

sasiparupudi1 — Wed, 22 Jul 2015 11:17:48 GMT

Always One Selected Value

Checking this option assures that one value will always be selected, which is useful in documents where the data only makes sense when one value is already selected, such as one currency rate. This option is enabled after one value is already selected in the list box. This option is not available for calculated fields.