topic Re: How to calculate values from Financial year start to the current date? in QlikView

How to calculate values from Financial year start to the current date?

Shriram_Sridhar — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I would like to calculate value for Financial start year to date.

The logic is that when I select the date as 31-03-2017, then the value must show from 01-04-2016 to 31-03-2017.

I have a date field called Dim_Date and amount field called Sales_Amount. How should I calculate for a financial year.

tresB — Tue, 29 Aug 2017 12:35:54 GMT

Try Something like:

Sum({<Dim_Date={'>=$(=YearStart(Max(Dim_Date),0,4)) <=$(=Max(Dim_Date)))'}>}Sales_Amount)

sunny_talwar — Tue, 29 Aug 2017 12:35:58 GMT

May be like this in set analysis

Date = {"$(='>=' & Date(YearStart(Max(Date), 0, 4), 'DD-MM-YYYY') & '<=' & Date(Max(Date), 'DD-MM-YYYY'))"}

sunny_talwar — Tue, 29 Aug 2017 12:36:41 GMT

I think it should be YearStart(...., 0, 4) instead of YearStart(...., 4)

tresB — Tue, 29 Aug 2017 12:39:39 GMT

How fast you type ! you noticed and posted even before I realized myself and corrected.