Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

If dont wildmatch

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

1 Solution

Accepted Solutions
maxgro
MVP
MVP

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

View solution in original post

4 Replies
datanibbler
Champion
Champion

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

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
Master III
Master III

try

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

Not applicable
Author

Thanks you guys.