topic Re: Min(Year) as a dimension in the script editor in QlikView

Min(Year) as a dimension in the script editor

Mon, 06 Jul 2015 12:31:14 GMT

Hi ,

I have a list of products and the month/year that they were first launched...

I want to see the min year of this.

I can calculate this simply using min(Year) as an expression in a pivot table. However I want this to be calculated in the script editor as a dimension so that I can use it in a pivot table -

any ideas?

Thanks

Re: Min(Year) as a dimension in the script editor

Peter_Cammaert — Mon, 06 Jul 2015 12:38:50 GMT

I'm not sure if I completely understand your requirement (it's rather slim on details), but let's assume that the use date is present in a facts table, together with the product ID (let's call that one Material). Then in your script, add the following after you load the facts:

LEFT JOIN(Facts)

LOAD Material, min(Year(UseDate)) AS FirstYearUsed

RESIDENT Facts

GROUP BY Material;

Best,

Peter

Re: Min(Year) as a dimension in the script editor

Mon, 06 Jul 2015 12:46:01 GMT

Lovely job - thanks