Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
YearStart(DateField, 0, 7)
YearEnd(DateField, 0, 7)
I don't have date field I only have fiscal year field.
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)