topic Re: STDEV row by row in App Development

STDEV row by row

BryanFontes — Mon, 21 Mar 2022 19:09:21 GMT

Hello gentlemen,

I'm stuck with a problem. I have a data set like this example:

PersonID	Score_Jan	Score_Feb	Score_Mar
10007	1	2	1
10008	2	3	4
10009	2	3	1

I need to add a column with the value for the standard deviation for all the scores for each Person ID. Do you guys know how to do it?

Re: STDEV row by row

rwunderlich — Mon, 21 Mar 2022 20:40:26 GMT

Assuming you have a fixed number of fields, use RangeStdev function.

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/RangeFunctions/rangestdev.htm

-Rob

Re: STDEV row by row

BryanFontes — Tue, 22 Mar 2022 14:36:01 GMT

Thanks a lot! I didn't know this function. Tbh, my data have a dynamic number of fields, but it's easy to solve with variables. I did something like:

Test:
LOAD * INLINE [
id, test1, test2, test3
1, 3, 2, 1
2, 2, 2, 1
3, 1,, 2
4, 2,, 3
5, 1, 1, 1
6, 2, 2, 2
7, 1, 2, 3
];

LET VNo.ofFields = NOOFFIELDS('Test'); // To find No.of Fields in the table

FOR i=2 TO $(VNo.ofFields)

LET VFieldName = FIELDNAME($(i),'Test'); // To find FieldName in the ith position.
FieldNames:
LOAD
$(i) AS ID,
'$(VFieldName)' AS Field
AUTOGENERATE 1;

NEXT i;

Fields:
LOAD
CONCAT(Field,', ', ID) AS Fields
RESIDENT FieldNames;

LET vFieldNames = PEEK('Fields', 0,'Fields');

DROP TABLES Fields, FieldNames;

SD_test:
LOAD
REP,
RangeStDev($(vFieldNames))
RESIDENT Test;

Re: STDEV row by row

Vijayqlik4171 — Tue, 22 Mar 2022 18:49:10 GMT

...