Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
swiftfahad
Contributor III
Contributor III

getting start and end date of fiscal year

HI All

I have a dimension of fiscal year in qlikview app  shown in selection box of my app

starting from 2000-2001 to 2022-2023....... my fiscal periods say (2000-2001) is 01-Jul -2000 to 30-Jun-2001

now I want to create a variable  that shows the start date and another variable shows the end data of fiscal year that i select in selection box.

e.g  when i select 2005-2006 in selection box

V_Startfyear= 01-jul-2005

V_Endfyear= 30-jun-2006

plz advice

 

Labels (1)
3 Replies
tresesco
MVP
MVP

YearStart(DateField, 0, 7)

YearEnd(DateField, 0, 7)

swiftfahad
Contributor III
Contributor III
Author

I don't have date field I only have fiscal year field.

vinieme12
Champion III
Champion III

you can use the same solution suggested by @tresesco  and replace datefield with makedate()

 

yearstart(makedate(Yearfield,1,1),0,7)

yearend(makedate(Yearfield,1,1),0,7)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.