set analysis

[vipin_mishra479]

i want a plant which are coming in vertical = '500060' and what ever the variable pass

[MayilVahanan]

Hi,

     Try this,

     =only({<verical = {'500060' } , model = {'$(variablename)'} >} plant)

     Make sure that, plant has a single value for vertical and variablevalue

      or

     Concat({<verical = {'500060' } , model = {'$(variablename)'} >} plant,',') gives plant with comma separation

     Hope it helps

[vipin_mishra479]

thanks ramasamy for a reply

i have use if(vertical = '500060' , model = '$(variablename)' >} plant) it gives the correct out put but i want two vartical

at a same time then it not show any value will u please suggest me the helpful answer

[#4]

Hi,

Try this

MinString ( {$<vertical={'500060','500061'}>} if ( model = variablename , Plant ) )

or

MinString ( if ( vertical = '500060' or vertical = '500061' , if ( model = variablename , Plant ) ) )

HTH

[vipin_mishra479]

sorry its not working bcz i m trying in list box