topic Re: Answer me about below questions in QlikView

Answer me about below questions

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Answer me about below questions

albertovarela — Thu, 08 Jun 2017 16:58:43 GMT

You may want to take a look at these functions:

inyeartodate,

inquartertodate,

inmonthtodate

Re: Answer me about below questions

Anonymous — Thu, 08 Jun 2017 16:59:48 GMT

Have a look:

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

Hope it helps!!

Re: Answer me about below questions

Anil_Babu_Samineni — Fri, 09 Jun 2017 04:31:25 GMT

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)