topic Re: I need help for summing up diff field values for a single field in QlikView https://community.qlik.com/t5/QlikView/I-need-help-for-summing-up-diff-field-values-for-a-single-field/m-p/496145#M185532 <HTML><HEAD></HEAD><BODY><P>I think you'll need to do something like in my example <A _jive_internal="true" href="https://community.qlik.com/message/359675#359675">here</A>. Or perhaps a more comprehensive and flexible solution like explained in <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/08/10/how-intervalmatch-solved-my-profit-and-loss-dilemma">this blog post</A>.</P></BODY></HTML> Fri, 21 Jun 2013 17:50:01 GMT Gysbert_Wassenaar 2013-06-21T17:50:01Z I need help for summing up diff field values for a single field https://community.qlik.com/t5/QlikView/I-need-help-for-summing-up-diff-field-values-for-a-single-field/m-p/496144#M185531 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P><SPAN style="font-size: 10pt;">I need help as want to create a straight table with few field values showing as dimension and expression for Bud</SPAN></P><P><SPAN style="font-size: 10pt;">for Total revenue=</SPAN></P><P><SPAN style="font-size: 10pt;">((DD109+DD110+DD111+DD112+DD113+DD114+DD115+DD116+DD131+DD117+DD119+DD120</SPAN></P><P>DD118+DD120+DD122+DD124+DD125+DD126+DD127)-(DD128))+(DD130+DD116+DD131+DD131</P><P>+DD134+DD174+DD173+DD137+DD138+DD139+DD175+DD141)</P><P></P><P>My issue is that when i am using these values they are also coming in the straight table as field values although i want to sum all these field values and dont want to show these field values under STR_DD_Desc FIELD i want to sum them up and show under Total revenue.And one more thing is how i can next field value suppose Revenue from operations under bud expression as for a new expression u will get a new column.Plz help i am attaching both the table view and my document.</P><P></P><P>Thanks in advance</P><P>Ferha Jafri</P></BODY></HTML> Fri, 21 Jun 2013 11:49:19 GMT https://community.qlik.com/t5/QlikView/I-need-help-for-summing-up-diff-field-values-for-a-single-field/m-p/496144#M185531 ferha_jafri 2013-06-21T11:49:19Z Re: I need help for summing up diff field values for a single field https://community.qlik.com/t5/QlikView/I-need-help-for-summing-up-diff-field-values-for-a-single-field/m-p/496145#M185532 <HTML><HEAD></HEAD><BODY><P>I think you'll need to do something like in my example <A _jive_internal="true" href="https://community.qlik.com/message/359675#359675">here</A>. Or perhaps a more comprehensive and flexible solution like explained in <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/08/10/how-intervalmatch-solved-my-profit-and-loss-dilemma">this blog post</A>.</P></BODY></HTML> Fri, 21 Jun 2013 17:50:01 GMT https://community.qlik.com/t5/QlikView/I-need-help-for-summing-up-diff-field-values-for-a-single-field/m-p/496145#M185532 Gysbert_Wassenaar 2013-06-21T17:50:01Z