topic Re: Make a selection based on another field in QlikView

Make a selection based on another field

Mon, 03 Oct 2011 11:56:29 GMT

Hi everybody,

I have a table with the fields say A, B, C, D. I would like to make a button that executes two actions simultaneously:

1) makes a selection of B based on a selection of C.

2) clear the selection of field C.

How can I make an action that executes 1)? It sounds really simple, but at the moment I cannot figure it out.

swuehl — Mon, 03 Oct 2011 12:01:10 GMT

Regarding 1)

(There are also some other threads about this, but this gives quite a good overview).

2) You could use an action Selection - Clear other fields

for this.

Regards,

Stefan

SunilChauhan — Mon, 03 Oct 2011 12:03:48 GMT

see the attached hope this help

lironbaram — Mon, 03 Oct 2011 12:04:56 GMT

hei

attach is an example

when you click the button it selects all the values <=5 in field F1

then select the possible in F2 then clears the field F1

Mon, 03 Oct 2011 12:10:36 GMT

'Select Possible', how can I have missed it

Thanks all!