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

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

surendra-m

Hi All,

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

 

Capture_qlikview1.PNG

 

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.

eg:

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.

 

 

 

Thanks,

Surendra