https://community.qlik.com/t5/QlikView/Multiply-a-field-value-in-pivot-table/m-p/273222#M582835 <HTML><HEAD></HEAD><BODY><P> well, if you select in Field "Texto Componente" you can see that the value in"Conos" is 0.01, but I have 3 rows, what I need is to multiply the value "Conos" by the number of rows in the field "Componentes Unicos".</P><P></P><P>I can´t get the multiplication.</P></BODY></HTML> Thu, 01 Dec 2011 21:37:54 GMT 2011-12-01T21:37:54Z https://community.qlik.com/t5/QlikView/Multiply-a-field-value-in-pivot-table/m-p/273220#M582832 <HTML><HEAD></HEAD><BODY><P>Hi everybody, I need to multiply the row value of a field in a pivot table,</P><P></P><P>In my table "Máquina (Estructuras)" I need to get te multiply of the field "componentes unicos" count with the field "Texto componente".</P><P></P><P>I tryed for some ways but I can´t make it. Could you guys help me?</P><P></P><P>I attached the app </P><P></P><P>I appreciate your time.</P></BODY></HTML> Thu, 01 Dec 2011 21:15:24 GMT https://community.qlik.com/t5/QlikView/Multiply-a-field-value-in-pivot-table/m-p/273220#M582832 2011-12-01T21:15:24Z https://community.qlik.com/t5/QlikView/Multiply-a-field-value-in-pivot-table/m-p/273221#M582834 <HTML><HEAD></HEAD><BODY><P>It seems to be working when I looked at it. With the selections that are made on open (What you saved with) all values available for the field "componentes unicos" are 1. If you change the selection and create another expression without this multiplication&nbsp; you can see the change</P></BODY></HTML> Thu, 01 Dec 2011 21:27:08 GMT https://community.qlik.com/t5/QlikView/Multiply-a-field-value-in-pivot-table/m-p/273221#M582834 2011-12-01T21:27:08Z https://community.qlik.com/t5/QlikView/Multiply-a-field-value-in-pivot-table/m-p/273222#M582835 <HTML><HEAD></HEAD><BODY><P> well, if you select in Field "Texto Componente" you can see that the value in"Conos" is 0.01, but I have 3 rows, what I need is to multiply the value "Conos" by the number of rows in the field "Componentes Unicos".</P><P></P><P>I can´t get the multiplication.</P></BODY></HTML> Thu, 01 Dec 2011 21:37:54 GMT https://community.qlik.com/t5/QlikView/Multiply-a-field-value-in-pivot-table/m-p/273222#M582835 2011-12-01T21:37:54Z https://community.qlik.com/t5/QlikView/Multiply-a-field-value-in-pivot-table/m-p/273223#M582837 <HTML><HEAD></HEAD><BODY><P>Oh all right. You want the count of the rows multiplied by Cronos not the value of the rows.</P><P></P><P>Try using the total and distinct qualifiers like this:</P><P></P><P>count(Distinct Total [Field]) </P></BODY></HTML> Fri, 02 Dec 2011 14:16:45 GMT https://community.qlik.com/t5/QlikView/Multiply-a-field-value-in-pivot-table/m-p/273223#M582837 2011-12-02T14:16:45Z