Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
You want to create a field with a constant value (the stddev of your other field values)?
You can do this using simple maths:
Standard deviation - Wikipedia, the free encyclopedia
But why don't you want to use the QV function?
edit:
If you want to create a field for the standard deviation, maybe like
A:
LOAD * INLINE [
Column A
1
5
6
8
15
];
JOIN LOAD
Stdev([Column A]) as STDEV
RESIDENT A;
Hi,
Check below from Qlikview Help file (F1)
For Front end
stdev([{set_expression}][ distinct ] [ total [<fld { , fld } >] ] expression)
Returns the aggregated standard deviation of expression or field iterated over the chart dimension(s).
This function has the same limitations for nested aggregation as the avg([{set_expression}] [ distinct ] [ total [<fld { , fld } >]] expression) function. The stdev function supports Set Analysis and the total qualifier in the same way as the avg([{set_expression}] [ distinct ] [ total [<fld { , fld } >]] expression) function.
Examples:
stdev(Sales)
stdev(X'Y/3)
stdev(distinct Price)
stdev(total Sales)
stdev({1} total Sales)
For Backend script
Returns the standard deviation of expression over a number of records as defined by a group by clause. If the word distinct occurs before the expression, all duplicates will be disregarded.
Example:
Load Month, stdev(Sales) as SalesStandardDeviation from abc.csv group by Month;
Hope this helps you.
Regards,
Jagan.