topic Re: Verification expression excel qlikview in QlikView

Verification expression excel qlikview

MauriceLudo — Mon, 18 Sep 2017 15:23:16 GMT

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

Re: Verification expression excel qlikview

Anil_Babu_Samineni — Mon, 18 Sep 2017 15:37:56 GMT

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,

Re: Verification expression excel qlikview

petter — Mon, 18 Sep 2017 15:40:49 GMT

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,

Re: Verification expression excel qlikview

vishsaggi — Mon, 18 Sep 2017 15:54:10 GMT

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]

))))

Re: Verification expression excel qlikview

MauriceLudo — Mon, 18 Sep 2017 16:07:31 GMT

the number of date 38 then in excel it is 608

Re: Verification expression excel qlikview

MauriceLudo — Mon, 18 Sep 2017 16:08:06 GMT

It does not work either

Re: Verification expression excel qlikview

MauriceLudo — Mon, 18 Sep 2017 16:08:13 GMT

It does not work either

Re: Verification expression excel qlikview

MauriceLudo — Mon, 18 Sep 2017 16:14:29 GMT

here is the application

Re: Verification expression excel qlikview

vishsaggi — Mon, 18 Sep 2017 16:28:04 GMT

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?

Re: Verification expression excel qlikview

MauriceLudo — Mon, 18 Sep 2017 16:33:41 GMT

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

Re: Verification expression excel qlikview

MauriceLudo — Tue, 19 Sep 2017 10:15:21 GMT

here is the file source