Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chadliagabsi
Creator II
Creator II

First line Value

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.

test1.png

1 Solution

Accepted Solutions
3 Replies
tresesco
MVP
MVP

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

chadliagabsi
Creator II
Creator II
Author

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

attachment is the sample data

test1.png

tresesco
MVP
MVP

PFA

Capture.JPG