topic calculated dimension in the front end in QlikView

calculated dimension in the front end

vikasshana — Mon, 11 Aug 2025 10:17:40 GMT

Hi,

I've the below data

Year Month PeriodID

2024 Jan 202401

2024 Feb 202402

2024 Mar 202403

2024 Dec 202412

2025 Jun 202506

2025 Jul 202507

I'm looking for a calculated dimension in the front end where it has to take Max Year and Max month of that year, expecting below value in calculated dimension in the front end

Jul 2025

Regards,

Re: calculated dimension in the front end

savioricardog — Mon, 11 Aug 2025 13:36:04 GMT

Hi @vikasshana
Try this "=MaxString({< PeriodID = {"$(=Max(PeriodID))"} >} TOTAL Month) &' '& MaxString( {< PeriodID = {"$(=Maxstring(PeriodID))"} >} TOTAL Year)" in a dimension column and check if it works (here it works haha)

Re: calculated dimension in the front end

vikasshana — Mon, 11 Aug 2025 18:20:17 GMT

This works perfect..!!! thanks for helping.

Re: calculated dimension in the front end

BrunPierre — Mon, 11 Aug 2025 18:26:13 GMT

You could try this

Date(Date#(Max(Aggr(Only(PeriodID), Year, Month)),'YYYYMM'),'MMM YYYY')