<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic How can I count results or expression in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/How-can-I-count-results-or-expression/m-p/658200#M1076000</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I have an expression like that&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;"&gt;if&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;(&lt;/SPAN&gt;&lt;SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;"&gt;count&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;(&lt;BR /&gt; {&amp;lt;&lt;BR /&gt; &lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;"&gt;[Year of conclusion]&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;=&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; {2014},&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;BR /&gt; &lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;"&gt;[Contract Conclusion Date]&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt; -= {&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;"&gt;"&amp;lt;=$(=&lt;/SPAN&gt;&lt;SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;"&gt;Date&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;"&gt;(&lt;/SPAN&gt;&lt;SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;"&gt;vNewC&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;"&gt;))"&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;}&lt;BR /&gt; &lt;BR /&gt; &amp;gt;}&lt;BR /&gt; &lt;/SPAN&gt;&lt;SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;DISTINCT&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;(&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;"&gt;[Contract Number]&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;) &lt;BR /&gt; ),'New','Old') &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;How can i count only new contractc and old ones&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;somefing like&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: black; font-size: 10pt; font-family: 'Courier New';"&gt;count([My ecpression] = 'New') does not work&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;or&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;count({&amp;lt;&lt;SPAN style="font-family: 'Courier New';"&gt;[My ecpression]&lt;/SPAN&gt;={'New'}&amp;gt;} &lt;SPAN style="font-family: 'Courier New';"&gt;[My ecpression]&lt;/SPAN&gt; )&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Sun, 27 Jul 2014 09:51:01 GMT</pubDate>
    <dc:creator />
    <dc:date>2014-07-27T09:51:01Z</dc:date>
    <item>
      <title>How can I count results or expression</title>
      <link>https://community.qlik.com/t5/QlikView/How-can-I-count-results-or-expression/m-p/658200#M1076000</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I have an expression like that&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;"&gt;if&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;(&lt;/SPAN&gt;&lt;SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;"&gt;count&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;(&lt;BR /&gt; {&amp;lt;&lt;BR /&gt; &lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;"&gt;[Year of conclusion]&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;=&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; {2014},&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;BR /&gt; &lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;"&gt;[Contract Conclusion Date]&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt; -= {&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;"&gt;"&amp;lt;=$(=&lt;/SPAN&gt;&lt;SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;"&gt;Date&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;"&gt;(&lt;/SPAN&gt;&lt;SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;"&gt;vNewC&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;"&gt;))"&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;}&lt;BR /&gt; &lt;BR /&gt; &amp;gt;}&lt;BR /&gt; &lt;/SPAN&gt;&lt;SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;DISTINCT&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;(&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;"&gt;[Contract Number]&lt;/SPAN&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;) &lt;BR /&gt; ),'New','Old') &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;How can i count only new contractc and old ones&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;somefing like&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: black; font-size: 10pt; font-family: 'Courier New';"&gt;count([My ecpression] = 'New') does not work&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN lang="RU" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"&gt;or&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;count({&amp;lt;&lt;SPAN style="font-family: 'Courier New';"&gt;[My ecpression]&lt;/SPAN&gt;={'New'}&amp;gt;} &lt;SPAN style="font-family: 'Courier New';"&gt;[My ecpression]&lt;/SPAN&gt; )&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sun, 27 Jul 2014 09:51:01 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-can-I-count-results-or-expression/m-p/658200#M1076000</guid>
      <dc:creator />
      <dc:date>2014-07-27T09:51:01Z</dc:date>
    </item>
  </channel>
</rss>

