topic Re: Autogenerate function in QlikView

Autogenerate function

Mon, 22 Aug 2011 18:55:07 GMT

I have a startdate and a enddate of a customer, for example:

Customer Startdate Enddate Value

1 01-01-2011 15-04-2011 10

1 16-04-2011 31-12-2011 20

2 01-01-2011 17-05-2011 15

How can I get the dates between those two datefields for each customer?

jonathandienst — Mon, 22 Aug 2011 19:13:10 GMT

To calculate in a dimension:

=Date#(Enddate, 'dd-mm-yyyy') - Date#(Startdate, 'dd-mm-yyyy;)

However, if you ensure that these values are dates in your load script, like this...

LOAD
     Customer, 
     Date(Date#(Startdate, 'dd-mm-yyyy')) AS Startdate,
     Date(Date#(Enddate, 'dd-mm-yyyy')) AS Enddate,
...
FROM ...;

Then

=Enddate - Startdate

will do the job.

Hope that helps

Jonathan

disqr_rm — Mon, 22 Aug 2011 19:22:22 GMT

Is this what you are looking for?

[code]

Data:

LOAD * INLINE [

Customer, Startdate, Enddate, Value

1, 01/01/2011, 04/15/2011, 10

1, 04/16/2011, 12/31/2011, 20

2, 01/01/2011, 05/17/2011, 15

];

NewData:

LOAD Customer,

date(Startdate + IterNo()-1) as Date,

Value

RESIDENT Data

While Startdate + IterNo() <= Enddate+1;

[/code]