topic Re: wildmatch function in QlikView

wildmatch function

QSense — Tue, 13 Nov 2012 17:15:09 GMT

Hello ,

I have a sql statement getting data from db

İn load expression I want to get a conditional data seen below

load *,

if ( wildmatch(mdbadmin.rootcause.sym,'Altyapi*','*Altyapi','*Altyapi*'),'Altyapı',

if ( wildmatch(mdbadmin.rootcause.sym,'Uygulama*','*Uygulama','*Uygulama*'),'Uygulama',

if ( wildmatch(mdbadmin.rootcause.sym,'Planli Calisma*','*Planli Calisma','*Planli Calisma*'),'Planli Calisma'))) as KOKNEDEN

;

sql :

select ...

mdbadmin.rootcause.sym as VardiyaRap_RootCause,

but I have getten error fields not found

Re: wildmatch function

Tue, 13 Nov 2012 17:40:09 GMT

Hello!

If you renamed field as "VardiyaRap_RootCause" in wildmatch function, should use this new field name and no mdbadmin.rootcause.sym, because mdbadmin.rootcause.sym no longer exists.

Regards...

Re: wildmatch function

QSense — Tue, 13 Nov 2012 18:27:05 GMT

Hi,

I used VardiyaRap_RootCause but it also didnt work

Re: wildmatch function

jeffmartins — Wed, 14 Nov 2012 15:06:23 GMT

Hi qliekview,

You can use the pick and wildmatch functions to solve this.

See the attached file. Hope it helps you.

Regards

Re: wildmatch function

Nagaraju_KCS — Sun, 03 Feb 2013 14:22:58 GMT

Hi,

please explain wildmatch function..

i am new to learn..