topic Re: field selection in QlikView

field selection

adiarnon — Sun, 07 Jun 2015 06:56:59 GMT

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

Re: field selection

kaushiknsolanki — Sun, 07 Jun 2015 07:01:25 GMT

Hi,

Please upload a sample qlikview file.

Regards,

Kaushik Solanki

Re: field selection

adiarnon — Sun, 07 Jun 2015 07:02:57 GMT

im sorry but i cant upload.

if you need more explanation let mr know...

Re: field selection

patroser — Sun, 07 Jun 2015 07:56:00 GMT

you need to set the trigger as following:

Field:

Perf_CC

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

Patrick

Re: field selection

adiarnon — Sun, 07 Jun 2015 08:04:12 GMT

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

Re: field selection

MarcoWedel — Sun, 07 Jun 2015 09:21:19 GMT

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

Preparing examples for Upload - Reduction and Data Scrambling

regards

Marco

Re: field selection

patroser — Sun, 07 Jun 2015 10:07:10 GMT

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

Re: field selection

antoniotiman — Sun, 07 Jun 2015 15:37:15 GMT

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

Re: field selection

adiarnon — Mon, 08 Jun 2015 05:46:33 GMT

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

Re: field selection

MarcoWedel — Mon, 08 Jun 2015 06:55:05 GMT

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

Header 1	Header 2	Header 3

Hope this helps

regards

Marco

Re: field selection

adiarnon — Mon, 08 Jun 2015 09:28:48 GMT

yes,

i know and i did it in the past.

but, in this problem its not helpping me

adi