11 Replies Latest reply: Jun 18, 2012 8:24 AM by Roberto Postma RSS

    Adding 'Start date' and 'End date' to the calendar dynamically


      Hi All,

      I have a small problem regarding calendar. I have the following fields in the 'Time' table.




      I have to add two new columns to the this table in the qlikview script.

      They are 'start date' and 'end date'.

      'start date' should be the April 1 of the current year and 'end date' should be March 31 of the next year.


      for the column with year key=10 start date='1-April-2010' and end date='31-March-2011'.

      We should not hard code for each column,

      Please suggest how we can modify the script to get the desired output.