1 Reply Latest reply: Feb 4, 2013 5:14 PM by Raghu Dubey RSS

    Default FYTD selection

    Raghu Dubey

      Hi QlikViewers,

       

      Am trying to accomplish a logic such that I am able to set the date range of Financial year to Date on document Open. So that all calculations are displaying data for the FYTD on document open and later on user can change the selections.

       

      My Fiscal year start on 1 Nov. So if today is 23rd Jan 2013, I want the document to open with the date range selection of 1 Nov 2012 to 23rd jan 2013.

       

      I read a few posts but they are setting variables on document open. I want to set the exact date ranges so that all formula calculations reflect that period automatically. Any ideas? I have my business date column and also have separate fields for FY month, year and quarter.

       

       

      Thanks

      Raghu