<?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 Re: Calculate percentage in Text object in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Calculate-percentage-in-Text-object/m-p/1590617#M738350</link>
    <description>&lt;P&gt;Try this instead&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;Num(
Count({&amp;lt;[Status] = {"COMPLETED"}&amp;gt;}[Status])
/
Count({&amp;lt;[DB Tech] = {"SQL","ORACLE","DB2-LUW"}&amp;gt;}[DB Tech])
, '#%')&lt;/LI-CODE&gt;&lt;P&gt;or&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;Num(
Count({&amp;lt;[Status] = {"COMPLETED"}&amp;gt;}[Status])
/
Count({&amp;lt;[DB Tech] = {"SQL","ORACLE","DB2-LUW"}&amp;gt;}[DB Tech])
, '#.%')&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Tue, 11 Jun 2019 18:50:53 GMT</pubDate>
    <dc:creator>sunny_talwar</dc:creator>
    <dc:date>2019-06-11T18:50:53Z</dc:date>
    <item>
      <title>Calculate percentage in Text object</title>
      <link>https://community.qlik.com/t5/QlikView/Calculate-percentage-in-Text-object/m-p/1590616#M738349</link>
      <description>&lt;P&gt;Need Help.&lt;/P&gt;&lt;P&gt;I have below expression in the text object , the final output needs to be a % rounded up. Below one is actually giving me with the decimals. Is there a better way to do it?&lt;/P&gt;&lt;P&gt;Output=41.43989&amp;nbsp;&lt;/P&gt;&lt;P&gt;Expected= 41%&amp;nbsp; (also how do i add a percentage sign at the end)&lt;/P&gt;&lt;P&gt;=(count({&amp;lt;[Status]={"COMPLETED"}&amp;gt;}[Status])&lt;BR /&gt;/count({&amp;lt;[DB Tech]={"SQL","ORACLE","DB2-LUW"}&amp;gt;}[DB Tech])*100)&lt;/P&gt;</description>
      <pubDate>Wed, 25 Nov 2020 16:16:04 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Calculate-percentage-in-Text-object/m-p/1590616#M738349</guid>
      <dc:creator>qlikvw2019</dc:creator>
      <dc:date>2020-11-25T16:16:04Z</dc:date>
    </item>
    <item>
      <title>Re: Calculate percentage in Text object</title>
      <link>https://community.qlik.com/t5/QlikView/Calculate-percentage-in-Text-object/m-p/1590617#M738350</link>
      <description>&lt;P&gt;Try this instead&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;Num(
Count({&amp;lt;[Status] = {"COMPLETED"}&amp;gt;}[Status])
/
Count({&amp;lt;[DB Tech] = {"SQL","ORACLE","DB2-LUW"}&amp;gt;}[DB Tech])
, '#%')&lt;/LI-CODE&gt;&lt;P&gt;or&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;Num(
Count({&amp;lt;[Status] = {"COMPLETED"}&amp;gt;}[Status])
/
Count({&amp;lt;[DB Tech] = {"SQL","ORACLE","DB2-LUW"}&amp;gt;}[DB Tech])
, '#.%')&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 11 Jun 2019 18:50:53 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Calculate-percentage-in-Text-object/m-p/1590617#M738350</guid>
      <dc:creator>sunny_talwar</dc:creator>
      <dc:date>2019-06-11T18:50:53Z</dc:date>
    </item>
  </channel>
</rss>

