Expression for excluded value of Field

[Anonymous]

Hi,

  i want to find  expression for excluded value of field as -

Canada

Europe

India

Mexico

North America

Singapore

Thailand

if i selected 'Europe' , 'Mexico' and 'Singapore'

i want excluded fields as -

(Canada*|*India*|*NorthAmerica*|*Thailand)

qvw is attach for reference

Thanks in advance

[#2 · Accepted solution]

Hi Ankit,

maybe use exclude in your concat set analysis

Concat(distinct {<Country=e(Country)>} Country , '|')

hope that helps

Joe

[maxgro]

vList:

'("' & Concat(distinct {<Country=e(Country)>} Country , '"' & '|' & '"' ) & '")'

double quotes are for values with spaces, like "North America"

[sunny_talwar]

Not sure if you need those asteris symbol or not, but if you do you can modify Joe's expression as follows:

='(' & Concat(distinct {<Country=e(Country)>} Country , '*|*') & ')'

[Anonymous]

hi i have only one issue that if i select any other field its impact is not visible as -

if i select any other field and by which Country have only now excluded 'Europe' , 'Mexico' and 'Singapore'

than i am not getting same results..

thanks

[Anonymous]

hi i have only one issue that if i select any other field its impact is not visible as -

if i select any other field and by which Country have only now excluded 'Europe' , 'Mexico' and 'Singapore'

than i am not getting same results..

thanks

[Anonymous]

hi i have only one issue that if i select any other field its impact is not visible as -

if i select any other field and by which Country have only now excluded 'Europe' , 'Mexico' and 'Singapore'

than i am not getting same results..

thanks