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)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
When loading the data, I want to set variables of each group(A and B)
SET vAverageA = (average value of group A)//(14+23+53)/3
SET vAverageB = (average value of group B)//(4+63+13+7)/4
Does anybody know how to do this?
May be this:
LOAD * Inline [
LOAD Avg(value) as Avg,
Group By group
Order By group;
For i = 1 to FieldValueCount('group')
vField = FieldValue('group', $(i));
Where group = '$(vField)';
LET vAverage$(vField) = Peek('Avg');
DROP Table TempTable;
Drop Table AggrTable;
View solution in original post
Thank you so much!! It worked!!