Trigger automatic selection identical to possible values in another field.

[#1]

Hi.

I have 2 fields: YearWeek1 and YearWeek2.

And now I would like an working function/trigger - (the best would bee a trigger 'OnAnyChange') -, that automaticly makes a selection in YearWeek2 identical to the possible values in YearWeek1 - that is: the selection in YearWeek2 should always 'mirror' the possible values in YearWeek1.

I guess, it's easy, but I just can't get it to work.

[Anonymous]

This works for me:

sub FieldToField
set src=ActiveDocument.Fields("F1")
set dst=ActiveDocument.Fields("F2")
set F1Selections=src.GetPossibleValues
dst.SelectValues F1Selections
end sub

[#3 · Accepted solution]

Hi Michael S.

Thanks.

I got it to work with a Set Analysis and the concat-function as discribed in the thread:

http://community.qlik.com/media/p/72390.aspx