topic Re: Table Chart Expression to summarize all field values in QlikView https://community.qlik.com/t5/QlikView/Table-Chart-Expression-to-summarize-all-field-values/m-p/562478#M1149401 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Please read these two documents:</P><UL><LI><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-2380" style="color: #007fc0;">QlikCommunity Tip: How to get answers to your post?</A></LI><LI><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-1290" style="color: #007fc0;">Preparing examples for Upload - Reduction and Data Scrambling</A>.</LI></UL></BODY></HTML> Thu, 11 Jul 2013 16:22:37 GMT Gysbert_Wassenaar 2013-07-11T16:22:37Z Table Chart Expression to summarize all field values https://community.qlik.com/t5/QlikView/Table-Chart-Expression-to-summarize-all-field-values/m-p/562477#M1149400 <HTML><HEAD></HEAD><BODY><P>Hi Guys, I'm new in Qlikview and I'd appreciate a lot if somebody could help me to configurate this chart properly:</P><P></P><P>I want to create a Table Chart, that is a basic Inventory Rollforward.</P><P></P><P><IMG __jive_id="43882" class="jive-image-thumbnail jive-image" onclick="" alt="should be.png" src="/legacyfs/online/43882_should be.png" width="450" /></P><P></P><P>I'm using the <SPAN style="color: #339966; text-decoration: underline;"><STRONG>month field </STRONG></SPAN>(box) of the transactions table, to generate the RollForward for every month I want.</P><P></P><P>The problem is that instead of that report is generating this:</P><P></P><P><IMG __jive_id="43883" class="jive-image-thumbnail jive-image" onclick="" alt="now.png" src="https://community.qlik.com/legacyfs/online/43883_now.png" width="450" /></P><P>The Beg. Balance and Final Balance are calculated incorrectly.</P><P></P><P>What I need to know is which expression should I use in these two columns, to give me the TOTAL balance separate of the Transactions Generated every month (Purchases, Install, Repairs) which belong to the Month <SPAN style="text-decoration: underline;"><STRONG>Selected</STRONG></SPAN>. </P><P></P><P>Thanks in advance for any help provided</P><P></P><P>Jon</P></BODY></HTML> Wed, 10 Jul 2013 19:58:13 GMT https://community.qlik.com/t5/QlikView/Table-Chart-Expression-to-summarize-all-field-values/m-p/562477#M1149400 2013-07-10T19:58:13Z Re: Table Chart Expression to summarize all field values https://community.qlik.com/t5/QlikView/Table-Chart-Expression-to-summarize-all-field-values/m-p/562478#M1149401 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Please read these two documents:</P><UL><LI><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-2380" style="color: #007fc0;">QlikCommunity Tip: How to get answers to your post?</A></LI><LI><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-1290" style="color: #007fc0;">Preparing examples for Upload - Reduction and Data Scrambling</A>.</LI></UL></BODY></HTML> Thu, 11 Jul 2013 16:22:37 GMT https://community.qlik.com/t5/QlikView/Table-Chart-Expression-to-summarize-all-field-values/m-p/562478#M1149401 Gysbert_Wassenaar 2013-07-11T16:22:37Z