Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
BHoll
Contributor III
Contributor III

Sampling data

Hello everyone,

i Need a solution for the following Problem:

I have four products A,B,C,D. Every product has a value from 0 to 1. I want to create a line Diagramm where every point in the diagramm represents the average value of a random n-size -sample from the value.

For example i chose n = 5. Now the first point in the diagramm should be the average of 5 random values out of all values in my dataset. When i select a certain product, the first point in the diagramm should be the average of a 5 size random sample from the selected product.

Feel free to check out my sample file.

 

Best regards,

smbeholl

 

 

 

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

How close to true random does it need to be?  If I select n=5 for the same set of data at two different points in time, is it acceptable that I get the same results?  Or are you expecting different results each time you select the same n value?

-Rob

BHoll
Contributor III
Contributor III
Author

Hi Rob,

it would be sufficient if i get the same data points for the same n every time.