Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)