Last year march value in Last YTD

[qlikcheepirishe]

My requirement is to get  the last ytd

In last ytd it should display last year march value for the ytd below is the expression I am getting correct ytd can anyone guide me for the value to display on LAST YTD should display March value

YTD Expression=AVG(AGGR(AVG({1<FOR_DATE = {">=$(=DATE(YEARSTART(v_Date, 0, 4), 'DD/MM/YYYY'))"}, FOR_DATE = {"<=$(v_Date)"}>}Actual), Unit, KPI, UOM, Area, [Sub Area], Equipment))

Variables Used

v_Date=DATE(MAKEDATE(v_Max_Year, v_Max_Month), 'DD/MM/YYYY')

v_Max_Year==MAX(Year)

v_Max_Month =IF(GetSelectedCount(Month) <= 0, MAX(NUM_MONTH), NUM_MONTH) @

[Anonymous]

Hi,

Try this:

AVG({<Year={'$(vPriorYear)'},Month=,Day=,v_Date={'<=$(vPriorYearDate)'}>}Actual_Unit)

vPriorYear=MAX(Year) -1

Thanks,

[Anil_Babu_Samineni]

May be this?

AVG(AGGR(AVG({1<FOR_DATE = {">=$(=DATE(AddYears(YEARSTART(v_Date, 0, 4),-1), 'DD/MM/YYYY')) <=$(v_Date)"}>}Actual), Unit, KPI, UOM, Area, [Sub Area], Equipment))

[qlikcheepirishe]

it is displaying ytd value which already i have been displaying.

i want when user selects 2018.

then should reflect last year march (total ytd of previous year)value I m using financial year

[jyothish8807]

Try this:

AVG(AGGR(AVG({1<FOR_DATE = {">=$(=DATE(AddYears(YEARSTART(v_Date, 0, 4),-1), 'DD/MM/YYYY')) <=$(=DATE(AddYears(v_Date,-1),DD/MM/YYYY'))"}>}Actual), Unit, KPI, UOM, Area, [Sub Area], Equipment))

Br,

KC

[qlikcheepirishe]

not giving exact output somewhere near you are jyothish kc

[jyothish8807]

Hi Ramesh,

What is your max(num_month) ?

Why do you want to use YEARSTART(v_Date, 0, 4) ? YTD should start from 1st Jan, here it will start from 1st April.

Br,

KC

[jyothish8807]

Also what is the output of vDate ?

[qlikcheepirishe]

as per the expression of jyothish now i want to freeze the values.

means on any click event the value should b tact.

for example: bypass for the expression

[jyothish8807]

Change your variable like this then,

v_Max_Month =MAX({1}total NUM_MONTH)

v_Max_Year =MAX({1}total Year)