Set Analysis Calculation Measure

[tan_chungkam]

Hi all lovely people,

I need to get some figure.

I managed to get the Count of ID for the latest YearPeriod.

Now I would like to get the growth of the ID compare to previous YearPeriod.

I guess the measure should be using the [ Count ({<YearPeriod={"$(=max(YearPeriod))"}, OrderType={'New'}>}ID) ] to minus out the previous YearPeriod.

For e.g. now the new ID is 3, the growth of new ID should be -1. (previous YearPeriod is 20181202)

Please find attached my qvf and excel file.

LayoutNew ID MeasureExisting ID measurePart of my scripting

[Channa]

i think you need to check this variable

vPrevYearPeriod

this you looking for same month last year or same year previous month

[tan_chungkam]

I'm looking for Previous YearPeriod.

For e.g.  20190101's previous YearPeriod is 20181202.

20181202 previous YearPeriod is 20181201.