topic Re: Select a field auto select same value to other field in QlikView

Select a field auto select same value to other field

gidon500 — Fri, 07 Aug 2015 12:43:58 GMT

hi all

Is it possible to select a value a field MONTH1

and same value will be selected to other field MONTH2

I need that when I select MONTH1 AS 6 , THEN MONTH2 WILL BE AUTO SELECT AS 6 AS WELL

THANKS

GIDON

Re: Select a field auto select same value to other field

sunny_talwar — Fri, 07 Aug 2015 12:45:29 GMT

Add a trigger on MONTH1 field where you use Select in Field trigger to set MONTH2 with the value =MONTH1

Re: Select a field auto select same value to other field

sunny_talwar — Fri, 07 Aug 2015 12:50:26 GMT

Re: Select a field auto select same value to other field

gidon500 — Fri, 07 Aug 2015 12:58:35 GMT

IT WORKS GREAT IF WE SELECT ONLY ONE VALUE

IF I SELECT 2 VALUES IT DOES NOT WORK

IS THERE SOLUTION FOR THIS PURPOSE

GIDON

Re: Select a field auto select same value to other field

sunny_talwar — Fri, 07 Aug 2015 13:06:38 GMT

You can use this in that case for Search String

='[' & Concat(MONTH1, |) & ']'

Re: Select a field auto select same value to other field

gidon500 — Fri, 07 Aug 2015 13:14:46 GMT

HI SUN

TRIED IT , THERE IS AN ERROR

CAN YOU PLEASE PUT IT IN THE DOCUMNET TO SENT AT FIRST

THANKS YOU VERY MUCH FOR YOUR HELP

GIDON

Re: Select a field auto select same value to other field

ecolomer — Fri, 07 Aug 2015 13:18:14 GMT

Yes, see this example.

Re: Select a field auto select same value to other field

jonathandienst — Fri, 07 Aug 2015 13:22:03 GMT

Should be

='(' & Concat(MONTH1, '|') & ')'

Re: Select a field auto select same value to other field

sunny_talwar — Fri, 07 Aug 2015 13:22:04 GMT

Sorry, you need parenthesis and not square brackets:

='(' & Concat(MONTH1, '|') & ')'

Re: Select a field auto select same value to other field

gidon500 — Fri, 07 Aug 2015 14:32:44 GMT

THANKS

IT WORKS

GIDON

Re: Select a field auto select same value to other field

gidon500 — Fri, 07 Aug 2015 14:33:26 GMT

thanks

it works as needed

gidon

Re: Select a field auto select same value to other field

berndjaegle — Mon, 04 Jan 2016 13:14:14 GMT

Hi Enrique,

this works perfectly fine.

Great! Thanks.

For others: Please add Current Selections Box to see how it works.