KPI Fiscal Year Calculation

[Purushothaman]

My company fiscal calendar that starts Jul 1 and ends Jun 30. I would like to see sum of  OrderQty from 1-Jul-08 to  30-Jun-09 in KPI 

Attached is the dataset. Requesting Qliksense users expertise. Please help. Thank you in advance.

[Digvijay_Singh · Accepted solution]

You can achieve this by different ways but since you have given the date range, you can use this expression in the KPI -

Sum({<ShipDate={">=07/01/2008<=06/30/2009"}>}OrderQty)

But to make it more dynamic and to make things flexible I would rather create master calendar and add few indicators and fields like Year, Month Year, few indicators like rolling 12 months etc.

Thanks

[Purushothaman]

Thank you Vijay Singh for helping me . Much Appreciated your timely help. Cheers!