topic Re: Random date display. in QlikView

Random date display.

Tue, 14 Jul 2015 14:30:21 GMT

How to display random date which occurs for next 365 days.

Thanks in advance.

sunny_talwar — Tue, 14 Jul 2015 14:42:42 GMT

Try this:

=Date(Today() + Floor(Rand() * 365))

EDIT:

or this in the script:

Date(Today() + Floor(Rand() * 365)) as FutureDates

MK_QSL — Tue, 14 Jul 2015 15:00:07 GMT

LOAD

Date(Floor(Rand() * 365 + Today())) as Date

AutoGenerate 10000;

EDIT

LOAD

Date(Today() + Floor(RAND()*(AddYears(Today(),1) - Today() + 1))) as InvoiceDate

AutoGenerate 10000;

Kushal_Chawda — Tue, 14 Jul 2015 15:37:29 GMT

Try,

Load

date(RecNo()-1+Floor(Today())) As Date

AutoGenerate(365);

maxgro — Tue, 14 Jul 2015 15:43:26 GMT

load

date(today()+floor(rand()*365)+1) as next365date

AutoGenerate 1000;