topic Summary/Total by Dimension Based From Many Expression in QlikView https://community.qlik.com/t5/QlikView/Summary-Total-by-Dimension-Based-From-Many-Expression/m-p/956768#M947258 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I want to get summary/total by dimension, but the data quite complicated because it's actually results from many other expressions.</P><P>This is the screen shot where the "Total KPI Value MD YDT YO" is my goal, but right now the result is zero. I want to get the result like the number in red.</P><P><IMG alt="QVW.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/109455_QVW.jpg" style="height: 261px; width: 620px;" /></P><P>The "Total KPI Value MD YDT YO" that i want is the summary/total from "KPI Value MD YDT YO" by "Sales Force".</P><P>But the "KPI Value MD YDT YO" is actually calculation results from many other expressions.</P><P>I also attach the QVW file to explain the calculation.</P><P></P><P>Really really appreciate if anyone could help me on this.</P><P></P><P>Thanks a lot</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT pinkzfairy 2020-11-20T18:02:30Z Summary/Total by Dimension Based From Many Expression https://community.qlik.com/t5/QlikView/Summary-Total-by-Dimension-Based-From-Many-Expression/m-p/956768#M947258 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I want to get summary/total by dimension, but the data quite complicated because it's actually results from many other expressions.</P><P>This is the screen shot where the "Total KPI Value MD YDT YO" is my goal, but right now the result is zero. I want to get the result like the number in red.</P><P><IMG alt="QVW.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/109455_QVW.jpg" style="height: 261px; width: 620px;" /></P><P>The "Total KPI Value MD YDT YO" that i want is the summary/total from "KPI Value MD YDT YO" by "Sales Force".</P><P>But the "KPI Value MD YDT YO" is actually calculation results from many other expressions.</P><P>I also attach the QVW file to explain the calculation.</P><P></P><P>Really really appreciate if anyone could help me on this.</P><P></P><P>Thanks a lot</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/Summary-Total-by-Dimension-Based-From-Many-Expression/m-p/956768#M947258 pinkzfairy 2020-11-20T18:02:30Z