field selection

[adiarnon]

hi,

i have 2 fields 'CC' and 'Perf_CC'.

In one of my tabs the user have the filter CC and in other they have Perf_CC

I want that if the user will choose in one tab 'CC' When he move to the other tab the selection will move to the Perf_CC field.

so in the action of the tab i did-

select in field-Perf_CC

GetFieldSelections(CC,'|')&')'

and it working.

BUT!

if i selecter a value of two words (with a space) its not working!

how can i fix it???

adi

[kaushiknsolanki]

Hi,

Please upload a sample qlikview file.

Regards,

Kaushik Solanki

[adiarnon]

im sorry but i cant upload.

if you need more explanation let mr know...

[patroser]

Hi

you need to set the trigger as following:

Field:

Perf_CC

Search String:
='("' &Replace(GetFieldSelections(CC),', ','"|"') & '")'

Patrick

[adiarnon]

hi and tnx!

its working in the first time of moving from one tad to the other in the second time it-

("("C01201 - pp"|"C0199"|"C01300-LL KK")")

SO ITS NOT WORKING...

adi

[MarcoWedel]

please refer to this post on how to generate sample applications:

Preparing examples for Upload - Reduction and Data Scrambling

regards

Marco

[patroser]

Please find attached my sample application.

It's working proberly in this example.

I created a trigger on the second tab "OnActivateSheet" with the values mentioned before.

Please let me know if this works for your, or if I didn't understand the problem correctly.

Patrick

[antoniotiman]

Hi Adi,

according to what I see above, You should have

Field CC like  C01201 - pp,C0199,C01300-LL KK,...

and Field Pref_CC, I guess,  like C01201,C0199,C01300,.....

If so, You could use in 'Select in Field' Pref_CC

='('&Concat(DISTINCT SubField(Trim(CC),'-',1),'|')&')'

Regards,

Antonio

[adiarnon]

i know,

but i dont have internet in the computer im developing.

im using the web from other computer...

so it not possible to upload files

i wish i could

[MarcoWedel]

‌You can also create sample tables using the advanced editor of this forum:

Header 1	Header 2	Header 3

Hope this helps

regards

Marco