Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Database for presentation purpose

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

1 Solution

Accepted Solutions
Highlighted

This may give some inspiration, Scrambling Data

View solution in original post

4 Replies
Highlighted

This may give some inspiration, Scrambling Data

View solution in original post

Highlighted
Partner
Partner

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

Highlighted
Creator
Creator

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

Highlighted
Creator
Creator

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.