topic count in QlikView https://community.qlik.com/t5/QlikView/count/m-p/601078#M679795 <HTML><HEAD></HEAD><BODY><P><SPAN class="short_text" lang="en"><SPAN class="hps">Hello</SPAN> <SPAN class="hps">to all</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"></SPAN><BR /><SPAN lang="en"><SPAN class="hps">I need</SPAN> <SPAN class="hps">help,</SPAN> <SPAN class="hps">I'm working on</SPAN> <SPAN class="hps">a</SPAN> <SPAN class="hps">report that I</SPAN> <SPAN class="hps">need to have</SPAN> <SPAN class="hps">the percentages of</SPAN> <SPAN class="hps">hours</SPAN> <SPAN class="hps">to arrive</SPAN> <SPAN class="hps">agents</SPAN><SPAN>:</SPAN></SPAN></P><P><BR /><SPAN class="short_text" lang="en"><SPAN class="hps">example:</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></P><P><BR /></P><P class="MsoNormal"><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">7h </SPAN><SPAN style="mso-symbol-font-family: Wingdings; mso-char-type: symbol; mso-ascii-font-family: Calibri; mso-hansi-theme-font: minor-latin; font-family: Wingdings; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: Calibri;">--&gt; </SPAN><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">50%</SPAN></P><P class="MsoNormal"><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">8h </SPAN><SPAN style="mso-symbol-font-family: Wingdings; mso-char-type: symbol; mso-ascii-font-family: Calibri; mso-hansi-theme-font: minor-latin; font-family: Wingdings; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: Calibri;">--&gt; </SPAN><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">10%</SPAN></P><P class="MsoNormal"><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">9h </SPAN><SPAN style="mso-symbol-font-family: Wingdings; mso-char-type: symbol; mso-ascii-font-family: Calibri; mso-hansi-theme-font: minor-latin; font-family: Wingdings; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: Calibri;">--&gt; </SPAN><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">2%</SPAN></P><P class="MsoNormal"><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">10h </SPAN><SPAN style="mso-symbol-font-family: Wingdings; mso-char-type: symbol; mso-ascii-font-family: Calibri; mso-hansi-theme-font: minor-latin; font-family: Wingdings; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: Calibri;">--&gt;</SPAN><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">3%</SPAN></P><P class="MsoNormal"><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">11h </SPAN><SPAN style="mso-symbol-font-family: Wingdings; mso-char-type: symbol; mso-ascii-font-family: Calibri; mso-hansi-theme-font: minor-latin; font-family: Wingdings; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: Calibri;">--&gt; </SPAN><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">4%</SPAN></P><P class="MsoNormal"><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">12h </SPAN><SPAN style="mso-symbol-font-family: Wingdings; mso-char-type: symbol; mso-ascii-font-family: Calibri; mso-hansi-theme-font: minor-latin; font-family: Wingdings; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: Calibri;">--&gt; </SPAN><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">5%</SPAN></P><P class="MsoNormal"><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">13h </SPAN><SPAN style="mso-symbol-font-family: Wingdings; mso-char-type: symbol; mso-ascii-font-family: Calibri; mso-hansi-theme-font: minor-latin; font-family: Wingdings; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: Calibri;">--&gt; </SPAN><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">6%</SPAN></P><P></P><P><SPAN class="short_text" lang="en"><SPAN class="hps">I am looking for</SPAN> <SPAN class="hps">an expression</SPAN> <SPAN class="hps">that will allow me</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps">-<SPAN lang="en"><SPAN class="hps">count the number</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">agents</SPAN> <SPAN class="hps">in the database</SPAN> <SPAN class="hps">with the service</SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps">-<SPAN lang="en"><SPAN class="hps">then</SPAN> <SPAN class="hps">have a</SPAN> <SPAN class="hps">gender expression</SPAN> <SPAN class="hps">= (<SPAN class="short_text" lang="en"><SPAN class="hps">number</SPAN> <SPAN class="hps">hour</SPAN> <SPAN class="hps">delay * </SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN><SPAN class="short_text" lang="en"><SPAN class="hps">Total</SPAN> <SPAN class="hps">Agent) / 100</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps">For</SPAN> <SPAN class="hps">a percentage</SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></SPAN></SPAN></P></BODY></HTML> Fri, 04 Apr 2014 08:58:00 GMT 2014-04-04T08:58:00Z count https://community.qlik.com/t5/QlikView/count/m-p/601078#M679795 <HTML><HEAD></HEAD><BODY><P><SPAN class="short_text" lang="en"><SPAN class="hps">Hello</SPAN> <SPAN class="hps">to all</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"></SPAN><BR /><SPAN lang="en"><SPAN class="hps">I need</SPAN> <SPAN class="hps">help,</SPAN> <SPAN class="hps">I'm working on</SPAN> <SPAN class="hps">a</SPAN> <SPAN class="hps">report that I</SPAN> <SPAN class="hps">need to have</SPAN> <SPAN class="hps">the percentages of</SPAN> <SPAN class="hps">hours</SPAN> <SPAN class="hps">to arrive</SPAN> <SPAN class="hps">agents</SPAN><SPAN>:</SPAN></SPAN></P><P><BR /><SPAN class="short_text" lang="en"><SPAN class="hps">example:</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></P><P><BR /></P><P class="MsoNormal"><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">7h </SPAN><SPAN style="mso-symbol-font-family: Wingdings; mso-char-type: symbol; mso-ascii-font-family: Calibri; mso-hansi-theme-font: minor-latin; font-family: Wingdings; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: Calibri;">--&gt; </SPAN><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">50%</SPAN></P><P class="MsoNormal"><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">8h </SPAN><SPAN style="mso-symbol-font-family: Wingdings; mso-char-type: symbol; mso-ascii-font-family: Calibri; mso-hansi-theme-font: minor-latin; font-family: Wingdings; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: Calibri;">--&gt; </SPAN><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">10%</SPAN></P><P class="MsoNormal"><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">9h </SPAN><SPAN style="mso-symbol-font-family: Wingdings; mso-char-type: symbol; mso-ascii-font-family: Calibri; mso-hansi-theme-font: minor-latin; font-family: Wingdings; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: Calibri;">--&gt; </SPAN><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">2%</SPAN></P><P class="MsoNormal"><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">10h </SPAN><SPAN style="mso-symbol-font-family: Wingdings; mso-char-type: symbol; mso-ascii-font-family: Calibri; mso-hansi-theme-font: minor-latin; font-family: Wingdings; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: Calibri;">--&gt;</SPAN><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">3%</SPAN></P><P class="MsoNormal"><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">11h </SPAN><SPAN style="mso-symbol-font-family: Wingdings; mso-char-type: symbol; mso-ascii-font-family: Calibri; mso-hansi-theme-font: minor-latin; font-family: Wingdings; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: Calibri;">--&gt; </SPAN><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">4%</SPAN></P><P class="MsoNormal"><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">12h </SPAN><SPAN style="mso-symbol-font-family: Wingdings; mso-char-type: symbol; mso-ascii-font-family: Calibri; mso-hansi-theme-font: minor-latin; font-family: Wingdings; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: Calibri;">--&gt; </SPAN><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">5%</SPAN></P><P class="MsoNormal"><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">13h </SPAN><SPAN style="mso-symbol-font-family: Wingdings; mso-char-type: symbol; mso-ascii-font-family: Calibri; mso-hansi-theme-font: minor-latin; font-family: Wingdings; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: Calibri;">--&gt; </SPAN><SPAN lang="EN-US" style="mso-ansi-language: EN-US;">6%</SPAN></P><P></P><P><SPAN class="short_text" lang="en"><SPAN class="hps">I am looking for</SPAN> <SPAN class="hps">an expression</SPAN> <SPAN class="hps">that will allow me</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps">-<SPAN lang="en"><SPAN class="hps">count the number</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">agents</SPAN> <SPAN class="hps">in the database</SPAN> <SPAN class="hps">with the service</SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps">-<SPAN lang="en"><SPAN class="hps">then</SPAN> <SPAN class="hps">have a</SPAN> <SPAN class="hps">gender expression</SPAN> <SPAN class="hps">= (<SPAN class="short_text" lang="en"><SPAN class="hps">number</SPAN> <SPAN class="hps">hour</SPAN> <SPAN class="hps">delay * </SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN><SPAN class="short_text" lang="en"><SPAN class="hps">Total</SPAN> <SPAN class="hps">Agent) / 100</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps">For</SPAN> <SPAN class="hps">a percentage</SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></SPAN></SPAN></P></BODY></HTML> Fri, 04 Apr 2014 08:58:00 GMT https://community.qlik.com/t5/QlikView/count/m-p/601078#M679795 2014-04-04T08:58:00Z