topic Re: First line Value in QlikView

First line Value

chadliagabsi — Wed, 25 Nov 2020 16:16:04 GMT

Morning ,

I need to show just the first line for each MATRICULE_ID. i affect 1 in Entrees_AG for the first line and - for the rest.

my script :

LOAD

MATRICULE_AGENT,

MOTIF,

DATE_DEB_TEMP, MOIS, ANNEE

Resident D_VUE_DAA ;

Tab_intermediaire:

load RowNo() as ROWID,

MATRICULE_AGENT,VALEUR,DATE_DEB_TEMP,MOTIF,MOIS, ANNEE,

if(VALEUR=1,1) as Motif_A,

if(VALEUR=0,1) as Motif_B

Resident Tab_initiale

ORDER BY ROWID, MATRICULE_AGENT ;

drop Table Tab_initiale;

Thanks.

tresB — Mon, 12 Feb 2018 09:54:40 GMT

Could you post a sample data set and expected output against that?

chadliagabsi — Mon, 12 Feb 2018 10:16:00 GMT

This table is exactly what i need. the first value for the calculated field.

attachment is the sample data

tresB — Mon, 12 Feb 2018 10:26:53 GMT

PFA