topic insert previous value in the blank in QlikView

insert previous value in the blank

chadliagabsi — Thu, 08 Mar 2018 09:12:42 GMT

Hello,

I need to insert previous value of (DATE_FIN) in the blank of DATE_DEB and DATE_FIN.

I try this expression and it doesn't work:

if(MATRICULE=previous(MATRICULE)and MOTIF<>Previous(MOTIF) and IsNull(DATE_DEB) and IsNull(DATE_FIN),Previous(date(DATE_FIN,'DD/MM/YYYY')),0) as DATE_DEB

you find in attached my test case.

Thanks for helping.

Re: insert previous value in the blank

YoussefBelloum — Thu, 08 Mar 2018 09:16:02 GMT

Hi,

You can't do it on the front end using a table box, you should use a straight table.

is it ok for you ?

Re: insert previous value in the blank

chadliagabsi — Thu, 08 Mar 2018 09:18:53 GMT

Hello Youssef,

I do it in my script I have attached my script .

Re: insert previous value in the blank

YoussefBelloum — Thu, 08 Mar 2018 09:27:05 GMT

try this:

test :

LOAD * INLINE [

MATRICULE, NOM,MOTIF ,DATE_DEB, DATE_FIN,

1, DUPOND, RECRUTEMENT, 15/06/2015,17/08/2017

1, DUPOND, AVANCEMENT, 18/08/2017,31/01/2018

1, DUPOND, 'FIN CONTRAT','' , ''

];

test2:

LOAD RowNo() as id,

NOM,

MATRICULE,

MOTIF,

if(len(Trim(DATE_DEB))=0,Previous(DATE_FIN),DATE_DEB) as DATE_DEB,

if(len(Trim(DATE_FIN))=0,Previous(DATE_FIN),DATE_FIN) as DATE_FIN

RESIDENT test

order by MATRICULE;

DROP Table test;