Verification expression excel qlikview

[MauriceLudo]

Hi,

Please someone can confirme me if the expressions are the same, because I did not find the same results

- excel :

=SI(Fin réelle<>""

;Fin réelle;

SI(Date clôture<>"";Date clôture;

SI(OU(Statut="A traiter";Statut="En cours";Statut="");"";Modifié le)))

- Qlikview :

date(if([Fin réelle ] <>'', [Fin réelle ],

           if([Date clôture]<>'', [Date clôture],

          if(Statut='A traiter' or 'En cours' or '', [Modifié le],

          )))) as ClotureT,

Thank you

best regards

Maurice

[MauriceLudo]

here is the file source