topic Re: Percentage of DISTINCT COL1 having SUM(COL2) &lt; COL3 in QlikView https://community.qlik.com/t5/QlikView/Percentage-of-DISTINCT-COL1-having-SUM-COL2-lt-COL3/m-p/1302217#M619498 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Count({&lt;RAT = {"=Sum(GASTOS) &lt;= ORCADO"}&gt;} DISTINCT RAT)/</STRONG><SPAN style="font-size: 13.3333px;"><STRONG>Count(DISTINCT RAT)</STRONG></SPAN></P></BODY></HTML> Wed, 29 Mar 2017 15:18:00 GMT sunny_talwar 2017-03-29T15:18:00Z Percentage of DISTINCT COL1 having SUM(COL2) < COL3 https://community.qlik.com/t5/QlikView/Percentage-of-DISTINCT-COL1-having-SUM-COL2-lt-COL3/m-p/1302216#M619497 <HTML><HEAD></HEAD><BODY><P>Hi, community!</P><P></P><P>I'm having some throuble finding a solution for this. I have a set of data who shows the effort (hours) appointed untill now (GASTOS) per RAT, and I'm trying to find the percentage of DISTINCT RATs (summing the GASTOS column) that are above the estimated effort (ORCADO). The logic behind this is as follows:</P><P><IMG alt="qlik.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/158085_qlik.png" style="height: auto; margin-right: auto; margin-left: auto; display: block;" /></P><P>Can anyone help me with this?</P><P>Thanks a lot!</P><P>gbpadial.</P></BODY></HTML> Wed, 29 Mar 2017 12:50:49 GMT https://community.qlik.com/t5/QlikView/Percentage-of-DISTINCT-COL1-having-SUM-COL2-lt-COL3/m-p/1302216#M619497 2017-03-29T12:50:49Z Re: Percentage of DISTINCT COL1 having SUM(COL2) < COL3 https://community.qlik.com/t5/QlikView/Percentage-of-DISTINCT-COL1-having-SUM-COL2-lt-COL3/m-p/1302217#M619498 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Count({&lt;RAT = {"=Sum(GASTOS) &lt;= ORCADO"}&gt;} DISTINCT RAT)/</STRONG><SPAN style="font-size: 13.3333px;"><STRONG>Count(DISTINCT RAT)</STRONG></SPAN></P></BODY></HTML> Wed, 29 Mar 2017 15:18:00 GMT https://community.qlik.com/t5/QlikView/Percentage-of-DISTINCT-COL1-having-SUM-COL2-lt-COL3/m-p/1302217#M619498 sunny_talwar 2017-03-29T15:18:00Z Re: Percentage of DISTINCT COL1 having SUM(COL2) < COL3 https://community.qlik.com/t5/QlikView/Percentage-of-DISTINCT-COL1-having-SUM-COL2-lt-COL3/m-p/1302218#M619499 <HTML><HEAD></HEAD><BODY><P>Thanks, Sunny!</P><P></P><P>It worked like a charm! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 29 Mar 2017 17:07:24 GMT https://community.qlik.com/t5/QlikView/Percentage-of-DISTINCT-COL1-having-SUM-COL2-lt-COL3/m-p/1302218#M619499 2017-03-29T17:07:24Z