topic Re: AutoGenerate in QlikView

AutoGenerate

Sun, 06 Mar 2016 09:39:08 GMT

How generate 10 Random Date between 2 Dates

Re: AutoGenerate

oknotsen — Sun, 06 Mar 2016 11:45:11 GMT

First get the two dates in a variable.

Calculate the difference.

let vStartDate = num(date#('1-1-2016', 'D-M-YYYY'));
let vEndDate = num(date#('6-3-2016', 'D-M-YYYY'));
let vNumberOfDates = $(vEndDate) - $(vStartDate) + 1;

Create a table (using AutoGenerate) in which you randomly general number and multiply that by the difference.

theTable:
LOAD
date(floor(rand() * $(vNumberOfDates)) + $(vStartDate)) as RandomDate
AutoGenerate 10
;

See attachment.

Re: AutoGenerate

MarcoWedel — Sun, 06 Mar 2016 15:33:22 GMT

Hi,

another solution could be:

table1:
LOAD Date(MinDate+Floor(Rand()*(MaxDate-MinDate))) as RandDate
While IterNo()<=10;
LOAD '2016-01-01' as MinDate,
    '2016-03-06' as MaxDate
AutoGenerate 1;

hope this helps

regards

Marco

Re: AutoGenerate

Mon, 07 Mar 2016 13:04:12 GMT

Very good.

Thaanks

Re: AutoGenerate

oknotsen — Mon, 07 Mar 2016 16:35:53 GMT

If your question is now answered, please flag the Correct Answer (and optionally Helpful Answers).

If not, please make clear what part you still need help with .