Answer me about below questions

[#1]

What are the expression s for last 3 FY YTDs

Expressions for Q2,Q3 for last 3 FY years

Expressions for MTD for current and last 3 months???

Data should be change Dynamically

My Fy year start from April of every year

[albertovarela]

You may want to take a look at these functions:

inyeartodate,

inquartertodate,

inmonthtodate

[Anonymous]

Hi

Have a look:

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

Hope it helps!!

[Anil_Babu_Samineni]

I am not sure, Your intention over here. Perhaps this? Hope this helps to you

1) What are the expressions for last 3 FY YTDs

Sum({<Year=, Month=, Quarter=, Week=, DateField={">=$(=Num(YearStart(Max(DateField))))<=$(=Max(DateField))"}, , FYYear = {'$(=AddYears(Max(FYYear ),-3))'}>} Sales)

2) Expressions for Q2,Q3 for last 3 FY years

Sum({<Quarter = {'Q2','Q3'}>}Sales)

3) Expressions for MTD for current and last 3 months???

Sum({<Year=, Month=, Quarter=, Week=, DateField={">=$(=Num(MonthStart(Max(DateField))))<=$(=Max(DateField))"}, FYMonth = {'$(=AddMonths(Max(FYYear ),-3))'}>} Sales)

4) Data should be change Dynamically

Default, Qlik can do if data associate with each together

5) My Fy year start from April of every year

Here, You have to enable the sort expression like =Mod(Month(FYDate)+8,12)