Database for presentation purpose

[Anonymous]

Hi,

I've got an app with data from SQL database. I would like to use it to present somebody how Qlik is working. I wouldn't like to use the exact records from my client's base to protect them.  However I would like to use the app and the data model to show it to someone else. What is the fastest way to save the model but to show some random values, that would not reveal anything from the original data.

Thanks in advance,

Maciek

[Anonymous · Accepted solution]

This may give some inspiration, Scrambling Data

[shubham_singh]

rand() function gives you a random value between 0 & 1.

Try something like Sales*(rand()+0.7) as Sales.

To hide the name of company or products, try something like

'Company'&Autonumber(CompanyName,'Company') as CompanyName

[Anonymous]

Thank you Bill. It was helpful and gave me the point to start.

[Anonymous]

Thank you Shubham, it's a good and simple way to change the data. I saw it in the article that Bill has recommended me to read and you helped me to understand it's a good way to scramble data.