This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
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
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)
if([Clients Emeraude 1]<>'0' and WildMatch([Clients Emeraude 1],'1,7')>0,[Clients Emeraude 1],0)
Thanks you guys.