How to get financial start date of previous year from current date?

[Shubham_Deshmukh]

I have startdate & enddate of current year.

e.g.

Now If any1 select enddate = '1 May 2017' , then I want startdate = '1 Apr 2016' & enddate = '1 May 2016'

My expression will be lastyear be like

=dateField > startdate and dateField < enddate.

[Anil_Babu_Samineni]

Where are you trying this, set analysis?

[Shubham_Deshmukh]

Nope.Simple If else thats it.

[Shubham_Deshmukh]

For not considering current selections I will have to use set analysis thats it.

[Anil_Babu_Samineni]

To simplify try this

If(dateField > startdate and dateField < enddate, requiredfield)

And set analysis may be this

Only({<dateField = {"=dateField > startdate and =dateField < enddate"} >} measure)

[Shubham_Deshmukh]

Done Sir.

M getting previous year Financial yr start by using this,

=AddYears(makedate(year(Enddate),4),-1) gives 1 Apr of lastyear

[Anil_Babu_Samineni]

Your question is not similar to original thread

Anyway, mark your response as correct to close this thread

[Shubham_Deshmukh]

Thanks.

[Shubham_Deshmukh]

How to mark as correct ans?

[Anil_Babu_Samineni]

Qlik Community Tip: Marking Replies as Correct or Helpful