Discussion Board for collaboration on QlikView Scripting.
i need that possible values of one Field will be selected in another Field
I used therefore two Document Even Triggers "OnAnySelect" :
1) Select all possible values of Field A (MONTH_N)
2) Select in Field B (MONTH_F) all selected values of Field A (MONTH_N) = '(' & getfieldselections(A,'|') & ')'
Its working only on select MONTH_N but it should work on any select. Example on select YEAR_N.
See example attached
I will be thankful for any help!
Go to Solution.
Although not required, wouldn't it make it somewhat efficient to use Distinct with Concat?
='(' & Concat(Distinct MONTH_N, '|') & ')'
- remove select possible
- and use = '(' & concat(MONTH_N,'|') & ')'
of course Sunny
and congrat, now you're Legend (25000)
Hahahaha thank you for making me one .
Without your and other expert's guidance, I won't have been able to achieve this.