topic Re: field selection by other field GetFieldSelections in QlikView

field selection by other field GetFieldSelections

ilanbaruch — Mon, 18 Apr 2016 05:29:07 GMT

hi all I have two fields with different names (both hold the same values) in layout I want to select one field base on the other field selection, did it with GetFieldSelections but when more then one value is selected it wont work,

the distention.. is an expression in a straight/pivot table that will respond to filter selection any ideas?

advanced thanks,

ilan

Re: field selection by other field GetFieldSelections

tamilarasu — Mon, 18 Apr 2016 05:42:55 GMT

I'm not sure, if I understood your question.. Could you post a sample Qvw document and explain what you are trying to achieve.?

Re: field selection by other field GetFieldSelections

sujeetsingh — Mon, 18 Apr 2016 05:45:32 GMT

Here are few stuff for you sir

Use trigger to select values in one field based on values in another

Re: field selection by other field GetFieldSelections

kkkumar82 — Mon, 18 Apr 2016 05:50:10 GMT

Hi Use

expression in the field event trigger as below

='(' & Concat(Distinct yourfieldname], '|') & ')'

PFA document

Best regards

Kiran Kumar

Re: field selection by other field GetFieldSelections

Anonymous — Mon, 18 Apr 2016 06:01:14 GMT

to give the condition is like this if(getfieldselection(SALEMANID)>=1,1,0) THAN YOU GET RESULT

Re: field selection by other field GetFieldSelections

ilanbaruch — Mon, 18 Apr 2016 09:10:55 GMT

thank you, any idea how to 'clear' the corresponding field when user clears filter field ?