Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
here is the file source