topic Re: Aggr() issue in pivot table in App Development https://community.qlik.com/t5/App-Development/Aggr-issue-in-pivot-table/m-p/1758016#M58514 <P>What is your current not correct output and what is your desired output? Please explain.</P><P>&nbsp;</P> Tue, 03 Nov 2020 07:47:05 GMT Vegar 2020-11-03T07:47:05Z Aggr() issue in pivot table https://community.qlik.com/t5/App-Development/Aggr-issue-in-pivot-table/m-p/1758011#M58512 <P>Hi,</P><P>I having scenario to do aggregation at chart and pivot table level. I&nbsp; have created (Month, Quarterly,&nbsp; Half yearly and Yearly) base on the date field .</P><TABLE><TBODY><TR><TD>Response No</TD><TD>Project ID</TD><TD>Date</TD><TD>Account</TD><TD>Sub Account</TD><TD>Tower</TD><TD>Sub&nbsp; Tower</TD><TD>Response %</TD></TR><TR><TD>23307</TD><TD>3849</TD><TD>02-Apr-2020</TD><TD>Good wills</TD><TD>AB</TD><TD>MLD</TD><TD>DIV</TD><TD>80.00%</TD></TR><TR><TD>23702</TD><TD>3849</TD><TD>06-Apr-2020</TD><TD>Good wills</TD><TD>AB</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR><TR><TD>23767</TD><TD>6046</TD><TD>14-Apr-2020</TD><TD>Good wills</TD><TD>SC</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR><TR><TD>23813</TD><TD>12000</TD><TD>28-Apr-2020</TD><TD>Good wills</TD><TD>ALL</TD><TD>MLD</TD><TD>DIV</TD><TD>60.00%</TD></TR><TR><TD>23821</TD><TD>10374</TD><TD>21-Apr-2020</TD><TD>Good wills</TD><TD>HA</TD><TD>MLD</TD><TD>DIV</TD><TD>80.00%</TD></TR><TR><TD>23934</TD><TD>10149</TD><TD>12-May-2020</TD><TD>Good wills</TD><TD>LP</TD><TD>MLD</TD><TD>DIV</TD><TD>80.00%</TD></TR><TR><TD>23952</TD><TD>10974</TD><TD>07-May-2020</TD><TD>Good wills</TD><TD>GMBH</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR><TR><TD>24004</TD><TD>7312</TD><TD>14-May-2020</TD><TD>Good wills</TD><TD>BE</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR><TR><TD>24119</TD><TD>10899</TD><TD>29-May-2020</TD><TD>Good wills</TD><TD>BE</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR><TR><TD>24120</TD><TD>10836</TD><TD>27-May-2020</TD><TD>Good wills</TD><TD>BE</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR><TR><TD>24131</TD><TD>8622</TD><TD>02-Jun-2020</TD><TD>Good wills</TD><TD>LP</TD><TD>MLD</TD><TD>DIV</TD><TD>80.00%</TD></TR><TR><TD>24135</TD><TD>8853</TD><TD>05-Jun-2020</TD><TD>Good wills</TD><TD>BE</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR><TR><TD>24136</TD><TD>11314</TD><TD>28-May-2020</TD><TD>Good wills</TD><TD>LAE</TD><TD>MLD</TD><TD>DIV</TD><TD>80.00%</TD></TR><TR><TD>24143</TD><TD>9408</TD><TD>28-May-2020</TD><TD>Good wills</TD><TD>MO</TD><TD>MLD</TD><TD>DIV</TD><TD>80.00%</TD></TR><TR><TD>24148</TD><TD>4388</TD><TD>29-May-2020</TD><TD>Good wills</TD><TD>DM</TD><TD>MLD</TD><TD>DIV</TD><TD>80.00%</TD></TR><TR><TD>24150</TD><TD>11387</TD><TD>29-May-2020</TD><TD>Good wills</TD><TD>PAL</TD><TD>MLD</TD><TD>DIV</TD><TD>80.00%</TD></TR><TR><TD>24151</TD><TD>11548</TD><TD>02-Jun-2020</TD><TD>Good wills</TD><TD>PAL</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR><TR><TD>24153</TD><TD>4802</TD><TD>01-Jun-2020</TD><TD>Good wills</TD><TD>VID</TD><TD>MLD</TD><TD>DIV</TD><TD>80.00%</TD></TR><TR><TD>24181</TD><TD>11769</TD><TD>02-Jun-2020</TD><TD>Good wills</TD><TD>DM</TD><TD>MLD</TD><TD>DIV</TD><TD>80.00%</TD></TR><TR><TD>24192</TD><TD>9752</TD><TD>04-Jun-2020</TD><TD>Good wills</TD><TD>BE</TD><TD>MLD</TD><TD>DIV</TD><TD>80.00%</TD></TR><TR><TD>24202</TD><TD>9752</TD><TD>08-Jun-2020</TD><TD>Good wills</TD><TD>BE</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR><TR><TD>24242</TD><TD>2574</TD><TD>17-Jun-2020</TD><TD>Good wills</TD><TD>VID</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR><TR><TD>24249</TD><TD>12609</TD><TD>16-Jun-2020</TD><TD>GRBT</TD><TD>HO</TD><TD>MLD</TD><TD>DIV</TD><TD>80.00%</TD></TR><TR><TD>24403</TD><TD>9138</TD><TD>09-Jul-2020</TD><TD>Good wills</TD><TD>BE</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR><TR><TD>24474</TD><TD>10761</TD><TD>02-Jul-2020</TD><TD>Good wills</TD><TD>BE</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR><TR><TD>24611</TD><TD>10852</TD><TD>09-Jul-2020</TD><TD>Good wills</TD><TD>BE</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR><TR><TD>24638</TD><TD>10149</TD><TD>24-Jul-2020</TD><TD>Good wills</TD><TD>LP</TD><TD>MLD</TD><TD>DIV</TD><TD>80.00%</TD></TR><TR><TD>24691</TD><TD>6046</TD><TD>19-Jul-2020</TD><TD>Good wills</TD><TD>SC</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR><TR><TD>24739</TD><TD>12649</TD><TD>31-Jul-2020</TD><TD>Good wills</TD><TD>GMBH</TD><TD>MLD</TD><TD>DIV</TD><TD>80.00%</TD></TR><TR><TD>24971</TD><TD>11654</TD><TD>20-Aug-2020</TD><TD>Good wills</TD><TD>HA</TD><TD>MLD</TD><TD>DIV</TD><TD>80.00%</TD></TR><TR><TD>24979</TD><TD>12345</TD><TD>31-Aug-2020</TD><TD>Good wills</TD><TD>MO</TD><TD>MLD</TD><TD>DIV</TD><TD>80.00%</TD></TR><TR><TD>24980</TD><TD>7636</TD><TD>21-Aug-2020</TD><TD>Good wills</TD><TD>LP</TD><TD>MLD</TD><TD>DIV</TD><TD>80.00%</TD></TR><TR><TD>25068</TD><TD>3849</TD><TD>31-Aug-2020</TD><TD>Good wills</TD><TD>AB</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR><TR><TD>25115</TD><TD>5514</TD><TD>31-Aug-2020</TD><TD>Good wills</TD><TD>LE</TD><TD>MLD</TD><TD>DIV</TD><TD>80.00%</TD></TR><TR><TD>25223</TD><TD>10836</TD><TD>16-Sep-2020</TD><TD>Good wills</TD><TD>BE</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR><TR><TD>25262</TD><TD>12000</TD><TD>21-Sep-2020</TD><TD>Good wills</TD><TD>AL</TD><TD>MLD</TD><TD>DIV</TD><TD>60.00%</TD></TR><TR><TD>25299</TD><TD>11387</TD><TD>24-Sep-2020</TD><TD>Good wills</TD><TD>PAL</TD><TD>MLD</TD><TD>DIV</TD><TD>80.00%</TD></TR><TR><TD>25501</TD><TD>6046</TD><TD>12-Oct-2020</TD><TD>Good wills</TD><TD>SC</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR><TR><TD>25541</TD><TD>12914</TD><TD>12-Oct-2020</TD><TD>Good wills</TD><TD>DM</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR><TR><TD>25658</TD><TD>11314</TD><TD>20-Oct-2020</TD><TD>Good wills</TD><TD>LAE</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR><TR><TD>25736</TD><TD>3849</TD><TD>28-Oct-2020</TD><TD>Good wills</TD><TD>AB</TD><TD>MLD</TD><TD>DIV</TD><TD>100.00%</TD></TR></TBODY></TABLE><P>I have to create pivot table with these fields except Response No. but am not able to get response % correctly</P> Mon, 20 Dec 2021 21:08:46 GMT https://community.qlik.com/t5/App-Development/Aggr-issue-in-pivot-table/m-p/1758011#M58512 Leninond 2021-12-20T21:08:46Z Re: Aggr() issue in pivot table https://community.qlik.com/t5/App-Development/Aggr-issue-in-pivot-table/m-p/1758016#M58514 <P>What is your current not correct output and what is your desired output? Please explain.</P><P>&nbsp;</P> Tue, 03 Nov 2020 07:47:05 GMT https://community.qlik.com/t5/App-Development/Aggr-issue-in-pivot-table/m-p/1758016#M58514 Vegar 2020-11-03T07:47:05Z Re: Aggr() issue in pivot table https://community.qlik.com/t5/App-Development/Aggr-issue-in-pivot-table/m-p/1758063#M58527 <P>i have created pivot table with this data</P><P>Dimensions :&nbsp;Project ID, Account,&nbsp;Sub Account,&nbsp;Tower,&nbsp;Sub Tower,&nbsp;Month,&nbsp;Qtr, Half year and year</P><P>expression :&nbsp;Avg(Aggr(Avg(<SPAN>Response %</SPAN>),Project ID, Account,&nbsp;Sub Account,&nbsp;Tower,&nbsp;Sub Tower,&nbsp;Month,&nbsp;Qtr, Half year , year))</P><P>Base on this expression the rollup % values are not coming correctly&nbsp;</P> Tue, 03 Nov 2020 10:30:06 GMT https://community.qlik.com/t5/App-Development/Aggr-issue-in-pivot-table/m-p/1758063#M58527 Leninond 2020-11-03T10:30:06Z Re: Aggr() issue in pivot table https://community.qlik.com/t5/App-Development/Aggr-issue-in-pivot-table/m-p/1758069#M58528 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/123545">@Leninond</a>&nbsp;</P><P>Hope Response No is primary field, in that case, try like below</P><P><SPAN>Avg(Aggr(Avg(</SPAN><SPAN>Response %</SPAN><SPAN>),[Response No]))</SPAN></P> Tue, 03 Nov 2020 10:51:34 GMT https://community.qlik.com/t5/App-Development/Aggr-issue-in-pivot-table/m-p/1758069#M58528 MayilVahanan 2020-11-03T10:51:34Z Re: Aggr() issue in pivot table https://community.qlik.com/t5/App-Development/Aggr-issue-in-pivot-table/m-p/1758086#M58535 <P>Hi Mayil Vahanan,</P><P>[Response no] is granular low level data and primary field . I have tried Average value is not showing correctly.</P><P>&nbsp;</P> Tue, 03 Nov 2020 11:41:13 GMT https://community.qlik.com/t5/App-Development/Aggr-issue-in-pivot-table/m-p/1758086#M58535 Leninond 2020-11-03T11:41:13Z