topic Re: Calculated Dimension for MAX monthyear in QlikView

Calculated Dimension for MAX monthyear

jeckstein — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need to create a calculated dimension for the max(Month year) where future flag=0.

Example: today is 11/6/2016. Future flag is on 11/7/2016. I need a calculated dimension for date range 11/1/2016-11/30/2016.

But if I select Monthyear Oct-2016. I need a calculated dimension for date range 10/1/2016-10/31/2016.

I have been using set analysis like this (If this helps)

{<MonthYearID={$(=max({<FutureFlag={0}>}MonthYearID))}>}

Thanks in advance!!!

MK_QSL — Mon, 07 Nov 2016 08:47:16 GMT

Provide sample data or sample app to work..

Anil_Babu_Samineni — Mon, 07 Nov 2016 08:59:02 GMT

Set Analysis, You are expecting this?

If(MonthName = GetFieldSelections(MonthName), Sum({<DateField = {'>=' & MonthStart(DateField) '<=' MonthEnd(DateField)}>} Sales))

dineshm030 — Mon, 07 Nov 2016 09:43:15 GMT

Hi,

May be this expression will be helping to you....

{<MonthYearID = {">=$(MonthStart(MonthYearID )<=$(MonthEnd(MonthYearID )"}>}