topic Re: test data incresing sales in QlikView

test data incresing sales

felcar2013 — Wed, 03 May 2017 10:44:01 GMT

Hi community

i generated sample data (approx. 90.000 records) for a Dashboard purpose, but need increasing sales per month, and keeping some variability in the daily data as i also need weekly data.

Do you know any automatic way to alter the data so that i can get this result?

thanks

felipe

Re: test data incresing sales

tresB — Wed, 03 May 2017 10:52:28 GMT

You can use Rand() or simply:

Load

Rowno() as Data

Autogenerate 10000000;

Or a little bit of modification to it to fit your requirement, may be.

Re: test data incresing sales

felcar2013 — Wed, 03 May 2017 11:06:06 GMT

i attached the file i am using. due to different requirements on the user Interface i needed to create the data like that. I Need the the sales data (Umsatz) for all years 2014,15,16 and 17 Looks like for 2014, increasing. Is there any way to achieve this without doing Trial and error?

thanks