topic Re: wildcard search in QlikView

wildcard search

Anonymous — Tue, 07 Oct 2014 05:44:32 GMT

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.

Re: wildcard search

sushil353 — Tue, 07 Oct 2014 05:48:25 GMT

Hi,

Try to write expression in dimension tab.

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

also check the option for suppress null values.

HTH

sushil

Re: wildcard search

MarcoWedel — Tue, 07 Oct 2014 05:51:14 GMT

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

Re: wildcard search

PrashantSangle — Tue, 07 Oct 2014 05:51:28 GMT

Hi,

Use wildmatch()

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

Regards

Re: wildcard search

Anonymous — Tue, 07 Oct 2014 05:58:47 GMT

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

Re: Re: wildcard search

aveeeeeee7en — Tue, 07 Oct 2014 06:07:24 GMT

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

Re: wildcard search

Anonymous — Tue, 07 Oct 2014 06:10:07 GMT

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

Re: wildcard search

anbu1984 — Tue, 07 Oct 2014 06:12:25 GMT

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

Re: wildcard search

Anonymous — Tue, 07 Oct 2014 06:14:19 GMT

Hi Abhu

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

Re: Re: wildcard search

anbu1984 — Tue, 07 Oct 2014 06:19:14 GMT

Check this app

Re: wildcard search

Anonymous — Tue, 07 Oct 2014 06:23:46 GMT

Hi Anbu

I cant do like this as I cant load the values in the source file this is the false game.

I need an expression or loop to solve my requirement

Re: wildcard search

anbu1984 — Tue, 07 Oct 2014 06:28:08 GMT

Like this

Load CountryCode,Coutnry1,Upper(PurgeChar(CountryCode,'0123456789')) As Country Inline [

CountryCode,Coutnry1

Ind01,India

Ind02,East Ind

Ind03,West Ind

Ind04,India North

UAE1,UAE

UK01,UK

Uk02,UKWest

UK03,MidUK

US01,US

US02,East US ];