This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I'm stuck with a problem. I have a data set like this example:
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?
Assuming you have a fixed number of fields, use RangeStdev function.
View solution in original post
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, test31, 3, 2, 12, 2, 2, 13, 1,, 24, 2,, 35, 1, 1, 16, 2, 2, 27, 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 FieldAUTOGENERATE 1;
Fields:LOAD CONCAT(Field,', ', ID) AS FieldsRESIDENT FieldNames;
LET vFieldNames = PEEK('Fields', 0,'Fields');
DROP TABLES Fields, FieldNames;