Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

QSense
Contributor II

wildmatch function

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

Tags (1)
4 Replies
Not applicable

Re: wildmatch function

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...

QSense
Contributor II

Re: wildmatch function

Hi,

I used VardiyaRap_RootCause but it also didnt work

jeffmartins
Contributor II

Re: wildmatch function

Hi qliekview,

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

See the attached file. Hope it helps you.

Regards

qv_testing
Valued Contributor

Re: wildmatch function

Hi,

please explain wildmatch function..

i am new to learn..

Community Browser