topic Re: Existing multiple line chart how to make it stack chart , so i can see the overall total amount by year trend ? in QlikView https://community.qlik.com/t5/QlikView/Existing-multiple-line-chart-how-to-make-it-stack-chart-so-i-can/m-p/904741#M658434 <HTML><HEAD></HEAD><BODY><P>Thank you very much it work fine now. i need to select the stack bar on the left.</P></BODY></HTML> Sat, 25 Apr 2015 10:34:25 GMT paulyeo11 2015-04-25T10:34:25Z Existing multiple line chart how to make it stack chart , so i can see the overall total amount by year trend ? https://community.qlik.com/t5/QlikView/Existing-multiple-line-chart-how-to-make-it-stack-chart-so-i-can/m-p/904738#M658431 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P></P><P>How to i hv below working expression , which is working fine :-</P><P></P><P></P><P>money(</P><P>sum({$&lt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; year=,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; month=,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MonthSeqNum = {"$(= '&gt;=' &amp; only(MonthSeqNum-12) &amp; '&lt;=' &amp; only(MonthSeqNum))"} &gt;}&nbsp; Amount*-1/$(ColumnDim98)/1000)</P><P>, $(vMoneyFormatK_GL))</P><P></P><P></P><P>How it display line chart of individual expense items.</P><P></P><P></P><P>Hope some one can help me make the chart1 to display overall total expense , by change the multiple line chart1 to single line chart or stack line chart. ( same as Table 1 total row amount , display at chart 1.</P><P></P><P></P><P></P><P></P><P>Paul</P></BODY></HTML> Sat, 25 Apr 2015 09:21:47 GMT https://community.qlik.com/t5/QlikView/Existing-multiple-line-chart-how-to-make-it-stack-chart-so-i-can/m-p/904738#M658431 paulyeo11 2015-04-25T09:21:47Z Re: Existing multiple line chart how to make it stack chart , so i can see the overall total amount by year trend ? https://community.qlik.com/t5/QlikView/Existing-multiple-line-chart-how-to-make-it-stack-chart-so-i-can/m-p/904739#M658432 <HTML><HEAD></HEAD><BODY><P>Enclosed my Qv Doc</P></BODY></HTML> Sat, 25 Apr 2015 09:22:42 GMT https://community.qlik.com/t5/QlikView/Existing-multiple-line-chart-how-to-make-it-stack-chart-so-i-can/m-p/904739#M658432 paulyeo11 2015-04-25T09:22:42Z Re: Existing multiple line chart how to make it stack chart , so i can see the overall total amount by year trend ? https://community.qlik.com/t5/QlikView/Existing-multiple-line-chart-how-to-make-it-stack-chart-so-i-can/m-p/904740#M658433 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>maybe like this?</P><P></P><P><IMG alt="QlikCommunity_Thread_161674_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/84994_QlikCommunity_Thread_161674_Pic1.JPG" style="height: 250px; width: 620px;" /></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sat, 25 Apr 2015 09:47:16 GMT https://community.qlik.com/t5/QlikView/Existing-multiple-line-chart-how-to-make-it-stack-chart-so-i-can/m-p/904740#M658433 MarcoWedel 2015-04-25T09:47:16Z Re: Existing multiple line chart how to make it stack chart , so i can see the overall total amount by year trend ? https://community.qlik.com/t5/QlikView/Existing-multiple-line-chart-how-to-make-it-stack-chart-so-i-can/m-p/904741#M658434 <HTML><HEAD></HEAD><BODY><P>Thank you very much it work fine now. i need to select the stack bar on the left.</P></BODY></HTML> Sat, 25 Apr 2015 10:34:25 GMT https://community.qlik.com/t5/QlikView/Existing-multiple-line-chart-how-to-make-it-stack-chart-so-i-can/m-p/904741#M658434 paulyeo11 2015-04-25T10:34:25Z