wildcard search

[Anonymous]

CountryCode	Coutnry1
US01	US
Uk01	UK
Ind03	West Ind
Ind02	East Ind
Ind01	India
Ind04	India North

Hi, I need the countrycodes of India only in a chart.

Don't hard card the values

I need the suggestions from you guys and kindly share the sample app.

[sushil353]

Hi,

Try to write expression in dimension tab.

=if(CountryCode='Ind*',CountryCode,'')

also check the option for suppress null values.

HTH

sushil

[MarcoWedel]

Maybe you could share some more information as to your input data, expected result and the logic to calculate this result.

This might help to answer your questions.

Regards

Marco

[PrashantSangle]

Hi,

Use wildmatch()

like

=if(wildmatch(CountryCode,'*Ind*'),CountryCode)

Regards

[Anonymous]

Thanks for your quick response.

I have  a bit more to additions to the Question.

CountryCode	Coutnry1
US01	US
Uk01	UK
Ind03	West Ind
Ind02	East Ind
Ind01	India
Ind04	India North
US02	East US
UK02	UKWest
UK03	MidUK
UAE1	UAE

I need to get the result in a chart either pivot/table box in such a way that if I select on India all the CountryCode related India only should display and if  I select on US all US related CountryCode should display.

should display the related countrycodes

[aveeeeeee7en]

Use this:

=if(Left(CountryCodes,3)='IND' AND WildMatch(CountryCodes,'*IND*'),'INDIA',

if(Left(CountryCodes,2)='US' AND WildMatch(CountryCodes,'*US*'),'US',

if(Left(CountryCodes,2)='UK' AND WildMatch(CountryCodes,'*UK*'),'UK',CountryNames))) AS NewCountryName

Also, see the Attachment to see your new requirement of Pivot Table Country names Selection.

Regards

Av7eN

[Anonymous]

Thnaks for the response

I don't want to hard code the values as Ind, us in the expresson

because I may have more columns as of now only 3 it can be done but I want the result in dynamically

[anbu1984]

Is it possible to add a field like below?

CountryCode	Coutnry1	Country
Ind01	India	India
Ind02	East Ind	India
Ind03	West Ind	India
Ind04	India North	India
UAE1	UAE	UAE
Uk01	UK	UK
UK02	UKWest	UK
UK03	MidUK	UK
US01	US	US
US02	East US	US

[Anonymous]

Hi Abhu

thanks for the reply even that can be acceptable until unless we have hardcoded the values.

[anbu1984]

Check this app