conditional calculation

[cacciad]

hello , can you help me .. I 'm starting on qlik sense.

I want  to calculate a field but only under conditions.

if the flied COMMENTAIRE is different if 100% then I calculate a difference between today and a particular limit date.

I can figure out what's wrong .. can you help me ? merci ! daniel 

if COMMENTAIRE <> '100%' then
= DATE_PREAVIS-Date(Now());
end if

[Taoufiq_Zarra]

if i understood correctly maye be :

if(wildmatch(COMMENTAIRE, '*100%*')>0,DATE_PREAVIS-today())

sinon tu peux partager un exemple de donnée pour voir claire

[cacciad]

merci  infiniment ..je vais tester !..

[cacciad]

fabulous ! it works  taouifiq!

if I want to test several values what would be the right coding ?

=if((wildmatch(COMMENTAIRE, '*0%*')>0) or ((wildmatch(COMMENTAIRE, '*25%*')>0)),DATE_PREAVIS-today())

would that work ?

[cacciad]

workss perfectly ! many  thanks again .

I have ecluded the 100% value

=if(wildmatch(COMMENTAIRE, '*100%*')=0,DATE_PREAVIS-today())

parfait ! 

[Taoufiq_Zarra · Accepted solution]

Parfait

if(wildmatch(COMMENTAIRE, '*100%*')>0,DATE_PREAVIS-today())