topic Groping and calculating counts by % in QlikView https://community.qlik.com/t5/QlikView/Groping-and-calculating-counts-by/m-p/181830#M47703 <HTML><HEAD></HEAD><BODY><P></P><P></P><P>Hello!</P><P>I have the following table:</P><P>TYPE MATCHING COUNTS</P><P>P Perfect_match 3</P><P>S Perfect_match 4<BR />T Perfect_match 1<BR />W Perfect_match 1<BR />X Perfect_match 1</P><P>I would need to get the following table:</P><P>MATCHING TYPE_VS_COUNTS</P><P>Perfect_match {P}30%;{S}40%;{T}10%;{W}10%;{X}10%;</P><P>Amount of types can vary, so when I reload the data, there could appear new types. Could anybody please explain me the logic how can I do that in QV?</P><P>Thanks,</P><P>Andrei</P><BR /><BR /> <BR /><BR /></BODY></HTML> Thu, 11 Nov 2010 08:38:01 GMT 2010-11-11T08:38:01Z Groping and calculating counts by % https://community.qlik.com/t5/QlikView/Groping-and-calculating-counts-by/m-p/181830#M47703 <HTML><HEAD></HEAD><BODY><P></P><P></P><P>Hello!</P><P>I have the following table:</P><P>TYPE MATCHING COUNTS</P><P>P Perfect_match 3</P><P>S Perfect_match 4<BR />T Perfect_match 1<BR />W Perfect_match 1<BR />X Perfect_match 1</P><P>I would need to get the following table:</P><P>MATCHING TYPE_VS_COUNTS</P><P>Perfect_match {P}30%;{S}40%;{T}10%;{W}10%;{X}10%;</P><P>Amount of types can vary, so when I reload the data, there could appear new types. Could anybody please explain me the logic how can I do that in QV?</P><P>Thanks,</P><P>Andrei</P><BR /><BR /> <BR /><BR /></BODY></HTML> Thu, 11 Nov 2010 08:38:01 GMT https://community.qlik.com/t5/QlikView/Groping-and-calculating-counts-by/m-p/181830#M47703 2010-11-11T08:38:01Z