topic clusterizing data by group quantity in QlikView https://community.qlik.com/t5/QlikView/clusterizing-data-by-group-quantity/m-p/1238864#M852767 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I am experiencing the following problem. I have a table with the fields ID, GROUP, X, Y. I want to create a calculated dimension that, for each single record (identified by the key ID), must have the value 'A' if the ratio of the average of X and with the average of Y done over the GROUP of membership of the record is equal or greater than 1; 'B' otherwise.</P><P>I have tried different ways but with no success. Does anyone have an idea on how to do that?</P><P></P><P>Thank you in advance,</P><P>Valerio</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z clusterizing data by group quantity https://community.qlik.com/t5/QlikView/clusterizing-data-by-group-quantity/m-p/1238864#M852767 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I am experiencing the following problem. I have a table with the fields ID, GROUP, X, Y. I want to create a calculated dimension that, for each single record (identified by the key ID), must have the value 'A' if the ratio of the average of X and with the average of Y done over the GROUP of membership of the record is equal or greater than 1; 'B' otherwise.</P><P>I have tried different ways but with no success. Does anyone have an idea on how to do that?</P><P></P><P>Thank you in advance,</P><P>Valerio</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/clusterizing-data-by-group-quantity/m-p/1238864#M852767 2020-11-25T16:16:04Z