Discussion board where members can get started with Qlik Sense.
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?
Go to Solution.
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;
Thank you so much!! It worked!!