topic Re: Default additional selections in QlikView

Default additional selections

Thu, 08 May 2014 08:47:11 GMT

Hi guys,

Need a solution to the following requirement

Given the below set of value

Type, Name

1 A

2 B

3 C

4 D

5 E

On selecting 1 in a list box, Type should take in values 1 and 4 i.e. 4 need to be the additional selected value in every case, no matter what the selection is made in Type.

Selected value 2 should also reflect Type = (2,4) as Current selection.

Same goes for Name i.e Selected value B should also reflect Name = (B,D) as Current selection.

Thanks

Re: Default additional selections

Roop — Thu, 08 May 2014 11:05:50 GMT

Create 2 sets of data with similar values as per the portion of script below and then set a document action to calculate the field W2 as V2 plus the content "D" as the image shows.

I set up the following and changed W1 from V1.

NewV:

Load * Inline [

V1, V2

1,A

2,B

3,C

4,D

5,E

];

NewW:

Load * Inline [

W1, W2

1,A

2,B

3,C

4,D

5,E

];

and then under document properties set up the new values as per the image attached. This adds "D" to the values already selected.

Hope this helps

Re: Default additional selections

Thu, 08 May 2014 12:26:39 GMT

It works.. (Y)

Thanks Rupert

Re: Default additional selections

Roop — Thu, 08 May 2014 12:29:43 GMT

Please mark as correct

Thanks

Re: Default additional selections

Greg_Hood — Thu, 08 May 2014 12:34:09 GMT

Another option to use in your trigger, which works with your specific example is to use "select possible". See attached, that will select all possible values available after selecting a Type.