if loop to set analysis

[satishsure]

vEndvalue is variable which get 1,2,3,4,5,6 on selection. These are fields to display in chart :

Name,[GState],[GCountry],[Sales Area],[Sales Region],[Seller Name]). I need to write set analysis for the below expression

if ('$(vEndvalue)' = '' ,Name,Pick(Match('$(vEndvalue)',1,2,3,4,5,6),Name,[GState],[GCountry],[Sales Area],[Sales Region],[Seller Name]))

[sunny_talwar]

Not sure, but may be this:

Pick(Alt($(vEndvalue), 1), 'Name', 'GState', 'GCountry', 'Sales Area', 'Sales Region', 'Seller Name')