topic Re: Object straight list in QlikView

Object straight list

Fri, 06 May 2011 18:07:58 GMT

Hi community.

How do I select certain default values from a select list?

Thanks.

Object straight list

rbecher — Fri, 06 May 2011 18:22:14 GMT

You have to explain more details. What are the certain default values, what is the selected list?

Do you mean a mapping table?

Object straight list

Fri, 06 May 2011 18:41:35 GMT

Hi.

I have a straight list, and i want to assign default values.

Thx

Object straight list

rbecher — Fri, 06 May 2011 18:50:45 GMT

Than I think you need a mapping list. Give me an example...

Re: Object straight list

rbecher — Fri, 06 May 2011 19:05:41 GMT

Ok, to give you an idea:

Defaults:

MAPPING LOAD

Value, Default

FROM....

Then you can use :

ApplyMap('Defaults', Value) => Default

and if you have no default for all values:

ApplyMap('Defaults', Value. 'Something Else') => Default or 'Something Else' if no default is found

- Ralf

PS: see online help

Object straight list

johnw — Fri, 06 May 2011 21:27:00 GMT

Do you mean that when you open the application, you want certain values to be selected? For instance, you want to select customer A by default? I believe you'd do that like this:

settings -> document properties -> triggers -> OnOpen -> Add Actions -> Add -> Selection -> Select in Field -> OK -> Field = Customer -> Search String = A

Object straight list

Sat, 07 May 2011 11:57:35 GMT

Thank you Sir John.

I'm satisfied.