topic How to create a Line Chart for this subtraction in QlikView https://community.qlik.com/t5/QlikView/How-to-create-a-Line-Chart-for-this-subtraction/m-p/1153480#M376685 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Anyone can help me how to create a line chart for this measure :</P><P>sum({$&lt;TAHUN = {"$(=max(TAHUN))"}, YEAR_MONTH_CAL&gt;} COMM_ORIG_AMT_IDR_PLF)&nbsp; </P><P>-</P><P>(sum({$&lt;YEAR_MONTH_CAL = {"$(=max(YEAR_MONTH_CAL))"}&gt;} BALANCE_IDR) - sum({&lt;TAHUN={$(=max(TAHUN)-1)},NUM_BULAN_C={12}, YEAR_MONTH_CAL&gt;}BALANCE_IDR))</P><P></P><P>Thanks</P></BODY></HTML> Thu, 14 Jul 2016 02:17:01 GMT d4rlie891 2016-07-14T02:17:01Z How to create a Line Chart for this subtraction https://community.qlik.com/t5/QlikView/How-to-create-a-Line-Chart-for-this-subtraction/m-p/1153480#M376685 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Anyone can help me how to create a line chart for this measure :</P><P>sum({$&lt;TAHUN = {"$(=max(TAHUN))"}, YEAR_MONTH_CAL&gt;} COMM_ORIG_AMT_IDR_PLF)&nbsp; </P><P>-</P><P>(sum({$&lt;YEAR_MONTH_CAL = {"$(=max(YEAR_MONTH_CAL))"}&gt;} BALANCE_IDR) - sum({&lt;TAHUN={$(=max(TAHUN)-1)},NUM_BULAN_C={12}, YEAR_MONTH_CAL&gt;}BALANCE_IDR))</P><P></P><P>Thanks</P></BODY></HTML> Thu, 14 Jul 2016 02:17:01 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-Line-Chart-for-this-subtraction/m-p/1153480#M376685 d4rlie891 2016-07-14T02:17:01Z Re: How to create a Line Chart for this subtraction https://community.qlik.com/t5/QlikView/How-to-create-a-Line-Chart-for-this-subtraction/m-p/1153481#M376686 <HTML><HEAD></HEAD><BODY><P>Add a line chart object to your sheet. Choose a field to use as dimension and add that to the chart. Then add your expression as chart expression. Done.</P></BODY></HTML> Thu, 14 Jul 2016 08:46:09 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-Line-Chart-for-this-subtraction/m-p/1153481#M376686 Gysbert_Wassenaar 2016-07-14T08:46:09Z