Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Please upload a sample qlikview file.
Regards,
Kaushik Solanki
im sorry but i cant upload.
if you need more explanation let mr know...
Hi
you need to set the trigger as following:
Field:
Perf_CC
Search String:
='("' &Replace(GetFieldSelections(CC),', ','"|"') & '")'
Patrick
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
please refer to this post on how to generate sample applications:
Preparing examples for Upload - Reduction and Data Scrambling
regards
Marco
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
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
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
You can also create sample tables using the advanced editor of this forum:
Header 1 | Header 2 | Header 3 |
---|---|---|
Hope this helps
regards
Marco