topic Re: Random value distribution of a value x in QlikView

Random value distribution of a value x

pamaxeed — Tue, 10 May 2016 11:26:33 GMT

Hi all,

is there a way in Qlik to distribute a value of for instance 100 over a set of lets say Relationship Manager ?

Input: Value x

Output: Random value distribution of x over a dimension y (e.g. Relationship Manager), whereby the sum of distributed values has to be x

Thanks,

Patric

Re: Random value distribution of a value x

Clever_Anjos — Tue, 10 May 2016 11:38:24 GMT

Use this approach: Recipe for a Histogram

@hic

Re: Random value distribution of a value x

avinashelite — Tue, 10 May 2016 11:39:32 GMT

could you please explain your requirement with the sample data ??

if you want to create random data then you could use the random() function

Re: Random value distribution of a value x

swuehl — Tue, 10 May 2016 11:40:20 GMT

Maybe like this for a integer based distribution:

LOAD * INLINE [
SalesManager
Peter
Paul
Mary
];

Let vValue = 100;
Let vSalesManagerCount = FieldValueCount('SalesManager');

LOAD Sum(Value),
SalesManager
Group by SalesManager;
LOAD 1 as Value,
FieldValue('SalesManager',Ceil(RAND()*$(vSalesManagerCount))) as SalesManager
AutoGenerate $(vValue);