<?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: Agg with Set analysis in App Development</title>
    <link>https://community.qlik.com/t5/App-Development/Agg-with-Set-analysis/m-p/1731596#M55832</link>
    <description>&lt;P&gt;Thank you!&lt;/P&gt;</description>
    <pubDate>Wed, 29 Jul 2020 06:47:56 GMT</pubDate>
    <dc:creator>swatitomar</dc:creator>
    <dc:date>2020-07-29T06:47:56Z</dc:date>
    <item>
      <title>Agg with Set analysis</title>
      <link>https://community.qlik.com/t5/App-Development/Agg-with-Set-analysis/m-p/1731499#M55823</link>
      <description>&lt;P&gt;Hi Team ,&amp;nbsp;&lt;/P&gt;&lt;P&gt;I'm trying create the share% on the basis of 2 Dimension in Pivot Table but not getting correct result as needed .&lt;/P&gt;&lt;P&gt;2 Group are there , now i want the share % individually on group basis.&lt;/P&gt;&lt;DIV class="mceNonEditable lia-copypaste-placeholder"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;TABLE border="1" width="24.210895166077044%"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD&gt;&lt;STRONG&gt;Count&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD&gt;&lt;STRONG&gt;Share%&lt;/STRONG&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="4.73447597639786%" height="27px"&gt;&lt;STRONG&gt;Group 1&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD width="19.986704362044843%" height="27px"&gt;&lt;STRONG&gt;2705452&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD width="19.986704362044843%"&gt;&lt;STRONG&gt;100%&lt;/STRONG&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="4.73447597639786%" height="27px"&gt;Only Customer&lt;/TD&gt;&lt;TD width="19.986704362044843%" height="27px"&gt;2475529&lt;/TD&gt;&lt;TD width="19.986704362044843%"&gt;91.5%&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="4.73447597639786%" height="27px"&gt;Only Partner&lt;/TD&gt;&lt;TD width="19.986704362044843%" height="27px"&gt;142333&lt;/TD&gt;&lt;TD width="19.986704362044843%"&gt;5.3%&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="4.73447597639786%" height="27px"&gt;Only Vendor&lt;/TD&gt;&lt;TD width="19.986704362044843%" height="27px"&gt;87590&lt;/TD&gt;&lt;TD width="19.986704362044843%"&gt;3.2%&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="4.73447597639786%" height="27px"&gt;&lt;STRONG&gt;Group 2&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD width="19.986704362044843%" height="27px"&gt;&lt;STRONG&gt;154821&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD width="19.986704362044843%"&gt;&lt;STRONG&gt;100%&lt;/STRONG&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="4.73447597639786%" height="27px"&gt;&amp;nbsp;Customer &amp;amp; Partner&lt;/TD&gt;&lt;TD width="19.986704362044843%" height="27px"&gt;112842&lt;/TD&gt;&lt;TD width="19.986704362044843%"&gt;72.9%&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="4.73447597639786%" height="24px"&gt;Vendor &amp;amp; Partner&lt;/TD&gt;&lt;TD width="19.986704362044843%" height="24px"&gt;1795&lt;/TD&gt;&lt;TD width="19.986704362044843%"&gt;1.2%&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="4.73447597639786%" height="29px"&gt;Customer &amp;amp; Vendor&lt;/TD&gt;&lt;TD width="19.986704362044843%" height="29px"&gt;40184&lt;/TD&gt;&lt;TD width="19.986704362044843%"&gt;26%&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;DIV class="mceNonEditable lia-copypaste-placeholder"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class="mceNonEditable lia-copypaste-placeholder"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class="mceNonEditable lia-copypaste-placeholder"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV class="mceNonEditable lia-copypaste-placeholder"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 23 Dec 2021 18:15:28 GMT</pubDate>
      <guid>https://community.qlik.com/t5/App-Development/Agg-with-Set-analysis/m-p/1731499#M55823</guid>
      <dc:creator>swatitomar</dc:creator>
      <dc:date>2021-12-23T18:15:28Z</dc:date>
    </item>
    <item>
      <title>Re: Agg with Set analysis</title>
      <link>https://community.qlik.com/t5/App-Development/Agg-with-Set-analysis/m-p/1731527#M55824</link>
      <description>&lt;P&gt;assuming you have count expression as&amp;nbsp;&amp;nbsp;&lt;STRONG&gt;count(ID)&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;you can try below expression for Share%&lt;/P&gt;&lt;P&gt;=count(ID)/count(&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;total&amp;lt;Group&amp;gt;&lt;/STRONG&gt;&lt;/FONT&gt;ID)&lt;/P&gt;</description>
      <pubDate>Tue, 28 Jul 2020 21:24:05 GMT</pubDate>
      <guid>https://community.qlik.com/t5/App-Development/Agg-with-Set-analysis/m-p/1731527#M55824</guid>
      <dc:creator>Kushal_Chawda</dc:creator>
      <dc:date>2020-07-28T21:24:05Z</dc:date>
    </item>
    <item>
      <title>Re: Agg with Set analysis</title>
      <link>https://community.qlik.com/t5/App-Development/Agg-with-Set-analysis/m-p/1731596#M55832</link>
      <description>&lt;P&gt;Thank you!&lt;/P&gt;</description>
      <pubDate>Wed, 29 Jul 2020 06:47:56 GMT</pubDate>
      <guid>https://community.qlik.com/t5/App-Development/Agg-with-Set-analysis/m-p/1731596#M55832</guid>
      <dc:creator>swatitomar</dc:creator>
      <dc:date>2020-07-29T06:47:56Z</dc:date>
    </item>
  </channel>
</rss>

