https://community.qlik.com/t5/QlikView/How-to-perform-aggregation/m-p/2505809#M1226396 <P>Hi,</P> <P>I've below data.</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="25%">As Of Month</TD> <TD width="25%">Period</TD> <TD width="25%">Num</TD> <TD width="25%">Den</TD> </TR> <TR> <TD width="25%">2025001</TD> <TD width="25%">2024005</TD> <TD width="25%">0</TD> <TD width="25%">0</TD> </TR> <TR> <TD width="25%">2025001</TD> <TD width="25%">2024006</TD> <TD width="25%">0</TD> <TD width="25%">0</TD> </TR> <TR> <TD width="25%">2025001</TD> <TD width="25%">2024010</TD> <TD width="25%">0</TD> <TD width="25%">0</TD> </TR> <TR> <TD width="25%">2025001</TD> <TD width="25%">2024011</TD> <TD width="25%">0</TD> <TD width="25%">0</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I'm trying to create chart with&nbsp;As Of Month, sum(Num) and Sum(Den) and end up with the below chart</P> <TABLE border="1"> <TBODY> <TR> <TD width="99.8153px">As Of Month</TD> <TD width="99.6449px">sum(Num)</TD> <TD width="99.6307px">sum(Den)</TD> </TR> <TR> <TD width="99.8153px">2025001</TD> <TD width="99.6449px">0</TD> <TD width="99.6307px">0</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>But expecting below output</P> <TABLE border="1" width="297px"> <TBODY> <TR> <TD width="99px">As Of Month</TD> <TD width="99px">sum(Num)</TD> <TD width="99px">sum(Den)</TD> </TR> <TR> <TD width="99px">2025001</TD> <TD width="99px">0</TD> <TD width="99px">0</TD> </TR> <TR> <TD width="99px">2025001</TD> <TD width="99px">0</TD> <TD width="99px">0</TD> </TR> <TR> <TD width="99px">2025001</TD> <TD width="99px">0</TD> <TD width="99px">0</TD> </TR> <TR> <TD width="99px">2025001</TD> <TD width="99px">0</TD> <TD width="99px">0</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <DIV id="ae_app" data-nosnippet=""><!-- Layout, Style or Voice Helpers --> <DIV id="ae_helpers" class="ae-module" style="display: none;">&nbsp;</DIV> <!-- Compliance --> <DIV id="ae_compliance" class="ae-module" style="display: none;"><!-- For autoSmartRem addNewWindowWarnings div is referenced in an aria-describedby --> <DIV id="audioeye_new_window_message" style="display: none;">Opens in new window</DIV> <DIV id="audioeye_pdf_message" style="display: none;">PDF Download</DIV> <DIV id="audioeye_word_message" style="display: none;">Word Download</DIV> <DIV id="audioeye_excel_message" style="display: none;">Excel Download</DIV> <DIV id="audioeye_powerpoint_message" style="display: none;">PowerPoint Download</DIV> <DIV id="audioeye_document_message" style="display: none;">Document Download</DIV> </DIV> <!-- Versioning Control Panel if versioning = true ! --> <!-- Launcher --> <!-- Toolbar --> <BR /> <ASIDE id="ae_toolbar" tabindex="0" aria-label="Accessibility options"></ASIDE> <!-- Site Menu --> <!-- Generic Aria Live message container --> <DIV id="ae_enabled_messages" class="ae-blurb-noaudio" aria-relevant="additions" aria-live="assertive">&nbsp;</DIV> <!-- Symbol definitions --> </DIV> <!-- end #ae_app --> Thu, 13 Feb 2025 18:31:45 GMT vikasshana 2025-02-13T18:31:45Z https://community.qlik.com/t5/QlikView/How-to-perform-aggregation/m-p/2505809#M1226396 <P>Hi,</P> <P>I've below data.</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="25%">As Of Month</TD> <TD width="25%">Period</TD> <TD width="25%">Num</TD> <TD width="25%">Den</TD> </TR> <TR> <TD width="25%">2025001</TD> <TD width="25%">2024005</TD> <TD width="25%">0</TD> <TD width="25%">0</TD> </TR> <TR> <TD width="25%">2025001</TD> <TD width="25%">2024006</TD> <TD width="25%">0</TD> <TD width="25%">0</TD> </TR> <TR> <TD width="25%">2025001</TD> <TD width="25%">2024010</TD> <TD width="25%">0</TD> <TD width="25%">0</TD> </TR> <TR> <TD width="25%">2025001</TD> <TD width="25%">2024011</TD> <TD width="25%">0</TD> <TD width="25%">0</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I'm trying to create chart with&nbsp;As Of Month, sum(Num) and Sum(Den) and end up with the below chart</P> <TABLE border="1"> <TBODY> <TR> <TD width="99.8153px">As Of Month</TD> <TD width="99.6449px">sum(Num)</TD> <TD width="99.6307px">sum(Den)</TD> </TR> <TR> <TD width="99.8153px">2025001</TD> <TD width="99.6449px">0</TD> <TD width="99.6307px">0</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>But expecting below output</P> <TABLE border="1" width="297px"> <TBODY> <TR> <TD width="99px">As Of Month</TD> <TD width="99px">sum(Num)</TD> <TD width="99px">sum(Den)</TD> </TR> <TR> <TD width="99px">2025001</TD> <TD width="99px">0</TD> <TD width="99px">0</TD> </TR> <TR> <TD width="99px">2025001</TD> <TD width="99px">0</TD> <TD width="99px">0</TD> </TR> <TR> <TD width="99px">2025001</TD> <TD width="99px">0</TD> <TD width="99px">0</TD> </TR> <TR> <TD width="99px">2025001</TD> <TD width="99px">0</TD> <TD width="99px">0</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <DIV id="ae_app" data-nosnippet=""><!-- Layout, Style or Voice Helpers --> <DIV id="ae_helpers" class="ae-module" style="display: none;">&nbsp;</DIV> <!-- Compliance --> <DIV id="ae_compliance" class="ae-module" style="display: none;"><!-- For autoSmartRem addNewWindowWarnings div is referenced in an aria-describedby --> <DIV id="audioeye_new_window_message" style="display: none;">Opens in new window</DIV> <DIV id="audioeye_pdf_message" style="display: none;">PDF Download</DIV> <DIV id="audioeye_word_message" style="display: none;">Word Download</DIV> <DIV id="audioeye_excel_message" style="display: none;">Excel Download</DIV> <DIV id="audioeye_powerpoint_message" style="display: none;">PowerPoint Download</DIV> <DIV id="audioeye_document_message" style="display: none;">Document Download</DIV> </DIV> <!-- Versioning Control Panel if versioning = true ! --> <!-- Launcher --> <!-- Toolbar --> <BR /> <ASIDE id="ae_toolbar" tabindex="0" aria-label="Accessibility options"></ASIDE> <!-- Site Menu --> <!-- Generic Aria Live message container --> <DIV id="ae_enabled_messages" class="ae-blurb-noaudio" aria-relevant="additions" aria-live="assertive">&nbsp;</DIV> <!-- Symbol definitions --> </DIV> <!-- end #ae_app --> Thu, 13 Feb 2025 18:31:45 GMT https://community.qlik.com/t5/QlikView/How-to-perform-aggregation/m-p/2505809#M1226396 vikasshana 2025-02-13T18:31:45Z https://community.qlik.com/t5/QlikView/How-to-perform-aggregation/m-p/2505817#M1226397 <P>Hi, so you want to see the same values in the dimension? Maybe using Dual([<SPAN>As Of Month],Period) as calculated dimension.</SPAN></P> <P><SPAN>It could be&nbsp; Dual([As Of Month],Num#(Period,0)) if Period is a string.</SPAN></P> <P>&nbsp;</P> <DIV id="ae_app" data-nosnippet=""><!-- Layout, Style or Voice Helpers --> <DIV id="ae_helpers" class="ae-module" style="display: none;">&nbsp;</DIV> <!-- Compliance --> <DIV id="ae_compliance" class="ae-module" style="display: none;"><!-- For autoSmartRem addNewWindowWarnings div is referenced in an aria-describedby --> <DIV id="audioeye_new_window_message" style="display: none;">Opens in new window</DIV> <DIV id="audioeye_pdf_message" style="display: none;">PDF Download</DIV> <DIV id="audioeye_word_message" style="display: none;">Word Download</DIV> <DIV id="audioeye_excel_message" style="display: none;">Excel Download</DIV> <DIV id="audioeye_powerpoint_message" style="display: none;">PowerPoint Download</DIV> <DIV id="audioeye_document_message" style="display: none;">Document Download</DIV> </DIV> <!-- Versioning Control Panel if versioning = true ! --> <!-- Launcher --> <!-- Toolbar --> <!-- Site Menu --> <!-- Generic Aria Live message container --> <DIV id="ae_enabled_messages" class="ae-blurb-noaudio" aria-relevant="additions" aria-live="assertive">&nbsp;</DIV> <!-- Symbol definitions --> </DIV> <!-- end #ae_app --> Thu, 13 Feb 2025 19:19:13 GMT https://community.qlik.com/t5/QlikView/How-to-perform-aggregation/m-p/2505817#M1226397 rubenmarin 2025-02-13T19:19:13Z https://community.qlik.com/t5/QlikView/How-to-perform-aggregation/m-p/2505911#M1226399 <P>thank you, it is working..!!!</P> Fri, 14 Feb 2025 10:13:15 GMT https://community.qlik.com/t5/QlikView/How-to-perform-aggregation/m-p/2505911#M1226399 vikasshana 2025-02-14T10:13:15Z