topic Calculate number of Min() in App Development

Calculate number of Min()

Max1 — Fri, 14 Feb 2020 19:10:22 GMT

Hi,

I'm new so tried here for the first time 🙂

I have a qvd like this :

A	B	C	date	nb
TEXT1	TEXT1	TEXT1	10/01/2018	1
TEXT2	TEXT2	TEXT2	20/01/2018	1
TEXT2	TEXT2	TEXT2	21/01/2018	1
TEXT3	TEXT3	TEXT3	30/01/2018	1
TEXT3	TEXT3	TEXT3	30/01/2018	1

I would like to obtain the nb of minimum date :

A	B	C	=min(date)	nb of minimum date
TEXT1	TEXT1	TEXT1	10/01/2018	1
TEXT2	TEXT2	TEXT2	20/02/2018	1
TEXT3	TEXT3	TEXT3	30/03/2018	2

I have tried this but it's not enough : Aggr(Min(date), A, B, C)

Do you know someting to do that ?

Re: Calculate number of Min()

Taoufiq_Zarra — Sat, 15 Feb 2020 22:42:26 GMT

Data: LOAD * INLINE [ A, B, C, date, nb TEXT1, TEXT1, TEXT1, 10/01/2018, 1 TEXT2, TEXT2, TEXT2, 20/01/2018, 1 TEXT2, TEXT2, TEXT2, 21/01/2018, 1 TEXT3, TEXT3, TEXT3, 30/01/2018, 1 TEXT3, TEXT3, TEXT3, 30/01/2018, 1 ]; output: noconcatenate load A,B,C, min(date) as min resident Data group by A,B,C; left join load * resident Data; drop table Data; final: noconcatenate load if(date=min,1,0) as flag,* resident output; drop table output;

Re: Calculate number of Min()

Max1 — Mon, 24 Feb 2020 08:11:46 GMT

First thank you for your solution.

I forget to mention explicitly I was trying to do this with Set Analysis and not in Script in order to calculate with a selected date in filter (pivot period)

Is there any possibility with Set Analysis (or not recommended) ?