A common use case in Qlik Sense is to generate some test data in order to demonstrate a function or to run some testing. The AutoGenerate function is a great way of getting a large number of rows with some made up data to test or demo over.
Recently I was asked to implement a Correlation Coefficient and having not used the correl function in Qlik before I wanted to check that it gave sensible results before putting it into a live app (spoiler: it works fine). To do this I used AutoGenerate to give me X values from 1 to 1,000 and then various Y values to give positive, negative and non correlated data sets.
This app gives the various views of the correlation coefficient, but more importantly it shows how to generate test data, including random values, random selections of dimensions and generated dummy IDs.
![Correl Function Screenshot.jpg Correl Function Screenshot.jpg](https://community.qlik.com/t5/image/serverpage/image-id/120183i27134C8D8067A6F6/image-size/large?v=v2&px=999)
The app is accompanied by a blog post, which can be found here:
https://www.quickintelligence.co.uk/generating-test-data-in-qlik-load-scripts/
If you have any comments or suggestions of other ways you can autogenerate test data please comment on this document, or on the comments on the blog post.
Cheers!
Steve
https://www.quickintelligence.co.uk/