Manipulate data in a table with setAnalysis

[SRSB]

Hello ! 

I'm new to Qlik Sense and I'm having trouble with manipulating data in a table chart.

I have this table:

What I want is to according to my ID OBSERVATION, if there is no defect, show only one line.

If there is a defect show only the lines that contains the defect.

Plus if there is a defect, i want to set the column FIRST DEFECT to yes if it's corresponding to the first date and no if not.

So in result I want to have this table:

what i have now as calculation is: 

FIRST DEFECT =If(samplingHour = Min(TOTAL<ObservationId>timestamp(samplingHour , 'YYYY/M/DD hh:mm:ss.ffffff')), 'YES','NO')

DEFECT  =if (BooleanValue2 >'0' ,defect, null())

Can you help me please.

Thank you so much.

Best regards.

[Taoufiq_Zarra]

Bonjour @SRSB ,

can you share a sample data (in excel, csv ... format ) and the expected output ?

[SRSB]

Hello,

Thanks you for your response.

In the attached file there is a sheet for the sample data and another one for the expected output.

Best regards,