Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
adiarnon
Creator III
Creator III

field selection

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

10 Replies
kaushiknsolanki
Luminary Alumni
Luminary Alumni

Hi,

Please upload a sample qlikview file.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
adiarnon
Creator III
Creator III
Author

im sorry but i cant upload.

if you need more explanation let mr know...

patroser
Partner
Partner

Hi

you need to set the trigger as following:

Field:

Perf_CC

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


Patrick

adiarnon
Creator III
Creator III
Author


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
Partner
Partner

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
Master III
Master III

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
Creator III
Creator III
Author


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 1Header 2Header 3

Hope this helps

regards

Marco