topic Re: Get minimum date by year in QlikView

Get minimum date by year

maxime66 — Fri, 27 Nov 2015 10:35:06 GMT

Hi,

i would like to duplicate on each line of year the min (date) in an expression (see example)

Thanxx

Fri, 27 Nov 2015 13:51:57 GMT

Maybe you want add something like the following to your load script?

[Data]:

LOAD date,

year(date) as year

FROM [your\source];

[Tmp_Minimum]:

LOAD year,

Date(Min(date), 'DD.MM.YYYY') as minimum

RESIDENT [Data]

GROUP BY year;

LEFT JOIN([Data])

LOAD year, minimum

RESIDENT [Tmp_Minimum];

DROP TABLE [Tmp_Minimum];

maxime66 — Fri, 27 Nov 2015 14:04:57 GMT

hi Dorothea,

thanks but i don't want to modify my script ...

can't we put a calculated dimension in aggr ? like :

aggr(min(date),year(date)) (doesn't work for me)

Fri, 27 Nov 2015 16:04:38 GMT

Hi,

try to use function