Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
biob_stein
Contributor

Select in Field based on possible values of another Field

Dear Community,

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!

1 Solution

Accepted Solutions

Re: Select in Field based on possible values of another Field

Although not required, wouldn't it make it somewhat efficient to use Distinct with Concat?

='(' & Concat(Distinct MONTH_N, '|') & ')'

4 Replies
MVP
MVP

Re: Select in Field based on possible values of another Field

try with

- remove select possible

- and use = '(' & concat(MONTH_N,'|') & ')'

Re: Select in Field based on possible values of another Field

Although not required, wouldn't it make it somewhat efficient to use Distinct with Concat?

='(' & Concat(Distinct MONTH_N, '|') & ')'

MVP
MVP

Re: Select in Field based on possible values of another Field

of course Sunny

and congrat, now you're Legend (25000)

Re: Select in Field based on possible values of another Field

Hahahaha thank you for making me one .

Without your and other expert's guidance, I won't have been able to achieve this.

Community Browser