topic Modify date in QlikView

Modify date

Tue, 21 Jul 2009 23:12:15 GMT

Hi There,

I'd need to modify a date in a pipeline management dashboard as follows

New_date = Existing_date + i months

if piepeline stage = 1 then i = 6 month

if pipeline stage = 2 then i = 5 month

(...)

My question is:

what is the script to create the New_date using the Existing_date ?

Thanks in advance for your feedback !

Tue, 21 Jul 2009 23:22:15 GMT

What are you loading the data from? Database? QVD?

In T-SQL, you can use:

DateAdd(m, 7 - pipeline_stage, Existing_date) As New_date

If you're loading from a QVD, you can use the built in QlikView function AddMonths:

AddMonths(Exsiting_date, 7 - pipeline_stage) As New_date

The "7 - pipeline_stage" is a guess at how i should be calculated based on you example.