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

[Anil_Babu_Samineni]

What are you getting when you use below one in list box as expression? What does '' indicates ??

If([Fin réelle ] <> ' ', [Fin réelle ],

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

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

          ))) as ClotureT,

[petter]

You will have to add the text I have bolded:

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

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

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

          )))) as ClotureT,

[vishsaggi]

OR try like removing an extra comma highlighted in red

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

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

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

          )))) as ClotureT,

OR this

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

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

       if ( Match(Statut, 'A traiter', 'En cours',  ''), [Modifié le]

           ))))

[MauriceLudo]

the number of date 38 then in excel it is 608

[MauriceLudo]

It does not work either

[MauriceLudo]

It does not work either

[MauriceLudo]

here is the application

[vishsaggi]

What is that you are expecting to see in your qvw file? Can you also share your Excel file to reload the data. ?

Can you give us what output you are looking for?

[MauriceLudo]

the number of cloture in source file is 608 for N1 developpement file d'attente and in qllikview file is 38