topic Re: If dont wildmatch in QlikView

If dont wildmatch

Thu, 17 Sep 2015 11:34:25 GMT

Hi everybody,

I want to know how i can do if dont wildmatch

Here my example : i want to have 1,7 as Seuil_Z1 if [Clients Emeraude] <> '0'

if(WildMatch([Clients Emeraude 1],<>'0'),'1,7') as Seuil_Z1,

If someone have a reponse.

Thanks

datanibbler — Thu, 17 Sep 2015 11:38:36 GMT

Hi feneman,

if I understand correctly your requirement, you just want to query if the field [Clients Emeraude] has some value other than 0.

You don't need a WildMatch to do that, though. A simple IF() query will suffice for that.

(you'd need WildMatch to find out whether that field has one of n particular values)

HTH

Best regards,

DataNibbler

maxgro — Thu, 17 Sep 2015 11:42:37 GMT

you can use not

if(not WildMatch([Clients Emeraude 1],'0'),'1,7') as Seuil_Z1,

but i think is better

if([Clients Emeraude] <> '0', 'something', 'something else') as .......

sasiparupudi1 — Thu, 17 Sep 2015 11:42:44 GMT

try

if([Clients Emeraude 1]<>'0' and WildMatch([Clients Emeraude 1],'1,7')>0,[Clients Emeraude 1],0)

Thu, 17 Sep 2015 11:52:00 GMT

Thanks you guys.