Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
BHoll
New 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
MVP & Luminary
MVP & Luminary

Re: Sampling data

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
New Contributor III

Re: Sampling data

Hi Rob,

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