topic Re: How to link two field names using trigger? in QlikView

How to link two field names using trigger?

Thu, 12 Jul 2012 07:22:26 GMT

Hi all,

I have a field name 'X' which i want to duplicate. Here is how I m doing it:

X as A,

X as B

now i want A and B to be linked in such a way that if i click on A the same changes should be applied on B.

Please let me know if anyone knows it.

Regards

Sagar Gupta

Jason_Michaelides — Thu, 12 Jul 2012 07:33:12 GMT

If you really can't link the fields then try this:

Create a variable vSelectionsA

'(' & Concat(DISTINCT Chr(34) & A & Chr(34),'|') & ')'

Then, in the OnSelect trigger for A, add an action for Select in Field, Field = B, Selection = $(vSelectionsA) without the equals sign.

I may have the syntax slightly wrong and can't test right now but this should get you there.

Hope this helps,

Jason

Anonymous — Thu, 12 Jul 2012 07:38:43 GMT

If you want the exact same selections in the second field, why don't you just create a second listbox and point that to field X as well?