topic Re: data generation in QlikView

data generation

nareshthavidishetty — Thu, 29 Sep 2016 17:52:30 GMT

hi all ,

can anyone tell me how to generate data think that I'm not having any source files

my requirement is lik generate data ,date,sunnydays such that atleast 40% days are sunnyin the year

autogenrate function I tried and generated date but not sunny days how can I generate data

sunny_talwar — Thu, 29 Sep 2016 17:54:37 GMT

Something like this?

Table:

LOAD Date(MakeDate(2014, 12, 31) + IterNo()) as Date,

If(Rand() <= 0.40, 'Sunny Days', 'Cloudy Days') as DayTypeFlag

AutoGenerate 1

While IterNo() <= MakeDate(2015, 12, 31) - MakeDate(2014, 12, 31);

nareshthavidishetty — Thu, 29 Sep 2016 18:16:52 GMT

I tried ur logic not working

LOAD
//RecNo() as S.no,

Date(MakeDate(2015,12,31)+recno()) as Date,
if(Rand()<=0.8,'Y','N') as sunny days

autogenerate 365

I couldn't understand this steps below

AutoGenerate 1

While IterNo() <= MakeDate(2015, 12, 31) - MakeDate(2014, 12, 31);

sunny_talwar — Thu, 29 Sep 2016 18:18:48 GMT

So this did not work? or did it?

LOAD
//RecNo() as S.no,

Date(MakeDate(2015,12,31)+recno()) as Date,
if(Rand()<=0.8,'Y','N') as sunny days

autogenerate 365

nareshthavidishetty — Thu, 29 Sep 2016 18:27:16 GMT

‌not working

sunny_talwar — Thu, 29 Sep 2016 18:30:32 GMT

Does this not look right?

79.45% are Yes and 20.55% are No?