topic Re: Total? All? in QlikView https://community.qlik.com/t5/QlikView/Total-All/m-p/66462#M788242 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>=Sum({&lt;Period={'Progressivo 2018'}&gt;} Mancanti) / Sum({&lt;Period={'Progressivo 2018'}&gt;} Total Ordini)</P></BODY></HTML> Wed, 07 Feb 2018 17:59:57 GMT jwjackso 2018-02-07T17:59:57Z Total? All? https://community.qlik.com/t5/QlikView/Total-All/m-p/66459#M788239 <HTML><HEAD></HEAD><BODY><P> <SPAN lang="EN-US" style="color: black; font-family: 'Segoe UI',sans-serif; font-size: 10pt;">I'd like to calculate the column so called "% Mancanti" (<SPAN style="color: black; font-family: 'Segoe UI',sans-serif; font-size: 10pt;">column "mancanti" on the <STRONG>sum of orders</STRONG> in that period</SPAN>). </SPAN></P><P><SPAN lang="EN-US" style="color: black; font-family: 'Segoe UI',sans-serif; font-size: 10pt;">Can you help me?</SPAN></P><P><SPAN lang="EN-US" style="color: black; font-family: 'Segoe UI',sans-serif; font-size: 10pt;"></SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="1229"><TBODY><TR><TD style="border-width: 1pt 0.5pt 0.5pt 1pt; border-style: solid; border-color: windowtext #7f7f7f #7f7f7f windowtext; background-color: #da9694;" width="215"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">Settimana</STRONG></TD><TD colspan="3" style="border-width: 1pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext #7f7f7f #7f7f7f black; background-color: yellow;" width="330"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">Progressivo 2018</STRONG></TD><TD colspan="3" style="border-width: 1pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext #7f7f7f #7f7f7f black; background-color: #d8e4bc;" width="330"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">2018-01-01</STRONG></TD><TD colspan="3" style="border-width: 1pt 1pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext black #7f7f7f; background-color: #d8e4bc;" width="330"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">2018-01-08</STRONG></TD></TR><TR><TD style="border-width: 0px 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: red #7f7f7f #7f7f7f windowtext; background-color: #f2f2f2;" width="215"><STRONG style="color: #ff0000; font-size: 12pt; font-family: Calibri;">DES_CAUSALE_INEVASO</STRONG></TD><TD style="border: 0px red; border-image: none;" width="110"><STRONG style="color: #ff0000; font-size: 12pt; font-family: Calibri;">Ordini</STRONG></TD><TD style="border: 0px red; border-image: none;" width="110"><STRONG style="color: #ff0000; font-size: 12pt; font-family: Calibri;">Mancanti</STRONG></TD><TD style="border: 0px red; border-image: none;" width="110"><STRONG style="color: #ff0000; font-size: 12pt; font-family: Calibri;">% Mancanti</STRONG></TD><TD style="border: 0px red; border-image: none;" width="110"><STRONG style="color: #ff0000; font-size: 12pt; font-family: Calibri;">Ordini</STRONG></TD><TD style="border: 0px red; border-image: none;" width="110"><STRONG style="color: #ff0000; font-size: 12pt; font-family: Calibri;">Mancanti</STRONG></TD><TD style="border: 0px red; border-image: none;" width="110"><STRONG style="color: #ff0000; font-size: 12pt; font-family: Calibri;">% Mancanti</STRONG></TD><TD style="border: 0px red; border-image: none;" width="110"><STRONG style="color: #ff0000; font-size: 12pt; font-family: Calibri;">Ordini</STRONG></TD><TD style="border: 0px red; border-image: none;" width="110"><STRONG style="color: #ff0000; font-size: 12pt; font-family: Calibri;">Mancanti</STRONG></TD><TD style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: red windowtext red red;" width="110"><STRONG style="color: #ff0000; font-size: 12pt; font-family: Calibri;">% Mancanti</STRONG></TD></TR><TR><TD style="border-width: 0px 0px 0px 1pt; border-style: none none none solid; border-color: black black black windowtext;"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">Totali</STRONG></TD><TD align="right" style="border: 0px black; border-image: none;"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">777.000</STRONG></TD><TD align="right" style="border: 0px black; border-image: none;"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">138.963</STRONG></TD><TD align="right" style="border: 0px black; border-image: none; background-color: #00b050;"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">17,88%</STRONG></TD><TD align="right" style="border: 0px black; border-image: none;"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">777.200</STRONG></TD><TD align="right" style="border: 0px black; border-image: none;"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">43.800</STRONG></TD><TD align="right" style="border: 0px black; border-image: none; background-color: #00b050;"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">5,64%</STRONG></TD><TD align="right" style="border: 0px black; border-image: none;"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">777.150</STRONG></TD><TD align="right" style="border: 0px black; border-image: none;"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">59.400</STRONG></TD><TD align="right" style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: black windowtext black black; background-color: #00b050;"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">7,64%</STRONG></TD></TR><TR><TD style="border-width: 0px 0px 0px 1pt; border-style: none none none solid; border-color: black black black windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">CONSEGNATI</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">500</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0</SPAN></TD><TD style="border: 0px black; border-image: none; background-color: #00b050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">700</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0</SPAN></TD><TD style="border: 0px black; border-image: none; background-color: #00b050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">650</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0</SPAN></TD><TD style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: black windowtext black black; background-color: #00b050;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD></TR><TR><TD style="border-width: 0px 0px 0px 1pt; border-style: none none none solid; border-color: black black black windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: black windowtext black black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD></TR><TR><TD style="border-width: 0px 0px 0px 1pt; border-style: none none none solid; border-color: black black black windowtext;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">Sospeso</EM></TD><TD align="right" style="border: 0px black; border-image: none;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">555.000</EM></TD><TD align="right" style="border: 0px black; border-image: none;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">68.000</EM></TD><TD align="right" style="border: 0px black; border-image: none; background-color: #00b050;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">8,75%</EM></TD><TD align="right" style="border: 0px black; border-image: none;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">555.000</EM></TD><TD align="right" style="border: 0px black; border-image: none;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">4.700</EM></TD><TD align="right" style="border: 0px black; border-image: none; background-color: #00b050;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">0,60%</EM></TD><TD align="right" style="border: 0px black; border-image: none;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">555.000</EM></TD><TD align="right" style="border: 0px black; border-image: none;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">5.400</EM></TD><TD align="right" style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: black windowtext black black; background-color: #00b050;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">0,69%</EM></TD></TR><TR><TD style="border-width: 0px 0px 0px 1pt; border-style: none none none solid; border-color: black black black windowtext;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">Non competenza</EM></TD><TD align="right" style="border: 0px black; border-image: none;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">45.000</EM></TD><TD align="right" style="border: 0px black; border-image: none;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">35.000</EM></TD><TD align="right" style="border: 0px black; border-image: none; background-color: #00b050;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">4,50%</EM></TD><TD align="right" style="border: 0px black; border-image: none;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">45.000</EM></TD><TD align="right" style="border: 0px black; border-image: none;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">31.000</EM></TD><TD align="right" style="border: 0px black; border-image: none; background-color: #00b050;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">3,99%</EM></TD><TD align="right" style="border: 0px black; border-image: none;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">45.000</EM></TD><TD align="right" style="border: 0px black; border-image: none;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">27.000</EM></TD><TD align="right" style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: black windowtext black black; background-color: #00b050;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">3,47%</EM></TD></TR><TR><TD style="border-width: 0px 0px 0px 1pt; border-style: none none none solid; border-color: black black black windowtext;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">Non disponibile</EM></TD><TD align="right" style="border: 0px black; border-image: none;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">98.000</EM></TD><TD align="right" style="border: 0px black; border-image: none;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">23.000</EM></TD><TD align="right" style="border: 0px black; border-image: none; background-color: #00b050;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">2,96%</EM></TD><TD align="right" style="border: 0px black; border-image: none;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">98.000</EM></TD><TD align="right" style="border: 0px black; border-image: none;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">1.300</EM></TD><TD align="right" style="border: 0px black; border-image: none; background-color: #00b050;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">0,17%</EM></TD><TD align="right" style="border: 0px black; border-image: none;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">98.000</EM></TD><TD align="right" style="border: 0px black; border-image: none;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">19.000</EM></TD><TD align="right" style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: black windowtext black black; background-color: #00b050;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">2,44%</EM></TD></TR><TR><TD style="border-width: 0px 0px 1pt 1pt; border-style: none none solid solid; border-color: black black windowtext windowtext;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">Nuovo</EM></TD><TD align="right" style="border-width: 0px 0px 1pt; border-style: none none solid; border-color: black black windowtext;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">78.500</EM></TD><TD align="right" style="border-width: 0px 0px 1pt; border-style: none none solid; border-color: black black windowtext;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">12.963</EM></TD><TD align="right" style="border: 0px black; border-image: none; background-color: #00b050;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">1,67%</EM></TD><TD align="right" style="border-width: 0px 0px 1pt; border-style: none none solid; border-color: black black windowtext;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">78.500</EM></TD><TD align="right" style="border-width: 0px 0px 1pt; border-style: none none solid; border-color: black black windowtext;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">6.800</EM></TD><TD align="right" style="border: 0px black; border-image: none; background-color: #00b050;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">0,87%</EM></TD><TD align="right" style="border-width: 0px 0px 1pt; border-style: none none solid; border-color: black black windowtext;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">78.500</EM></TD><TD align="right" style="border-width: 0px 0px 1pt; border-style: none none solid; border-color: black black windowtext;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">8.000</EM></TD><TD align="right" style="border-width: 0px 1pt 0px 0px; border-style: none solid none none; border-color: black windowtext black black; background-color: #00b050;"><EM style="color: #000000; font-size: 12pt; font-family: Calibri;">1,03%</EM></TD></TR></TBODY></TABLE><P><SPAN lang="EN-US" style="color: black; font-family: 'Segoe UI',sans-serif; font-size: 10pt;"></SPAN></P><P></P><P></P><P> Thank</P><P></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Total-All/m-p/66459#M788239 innoveff1 2020-11-25T16:16:04Z Re: Total? All? https://community.qlik.com/t5/QlikView/Total-All/m-p/66460#M788240 <HTML><HEAD></HEAD><BODY><P>What you have above is the expected output or is this what you are getting right now?</P></BODY></HTML> Wed, 07 Feb 2018 16:50:40 GMT https://community.qlik.com/t5/QlikView/Total-All/m-p/66460#M788240 sunny_talwar 2018-02-07T16:50:40Z Re: Total? All? https://community.qlik.com/t5/QlikView/Total-All/m-p/66461#M788241 <HTML><HEAD></HEAD><BODY><P>What's the SUM OF ORDER field?</P></BODY></HTML> Wed, 07 Feb 2018 16:51:56 GMT https://community.qlik.com/t5/QlikView/Total-All/m-p/66461#M788241 shiveshsingh 2018-02-07T16:51:56Z Re: Total? All? https://community.qlik.com/t5/QlikView/Total-All/m-p/66462#M788242 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>=Sum({&lt;Period={'Progressivo 2018'}&gt;} Mancanti) / Sum({&lt;Period={'Progressivo 2018'}&gt;} Total Ordini)</P></BODY></HTML> Wed, 07 Feb 2018 17:59:57 GMT https://community.qlik.com/t5/QlikView/Total-All/m-p/66462#M788242 jwjackso 2018-02-07T17:59:57Z