topic Set Analysis Max Month Year in QlikView

Set Analysis Max Month Year

jonathanrichey — Fri, 12 Oct 2018 14:31:35 GMT

Is it possible to nest a set analysis with the Max month and year?

Current set Analysis (working):

(sum({<PeriodType={'Rolling 12'}>}MonthYear_Flg))

Desired:

When adding the Max function the syntax returns an error in the expression:

(sum({<PeriodType={'Rolling 12'}, Max(AsOfDate)>}MonthYear_Flg))

dplr-rn — Fri, 12 Oct 2018 17:24:41 GMT

sure. in your expression

add

MonthYear={"$(=max(MonthYear))"}

or MonthYear={"$(=date(max(AsOfDate), 'MMM-YYYY'))"}

or if you dont have a master calendar

AsOfDate={">=$(=monthstart(max(AsOfDate)))"} // just great or equal to first of the month

jonathanrichey — Fri, 12 Oct 2018 18:43:20 GMT

Awesome! Thanks for the response Dilip!

dplr-rn — Fri, 12 Oct 2018 19:01:46 GMT

no problems