topic Re: Identify last 'Balance' value in Line Chart for a given day in QlikView https://community.qlik.com/t5/QlikView/Identify-last-Balance-value-in-Line-Chart-for-a-given-day/m-p/777279#M275496 <HTML><HEAD></HEAD><BODY><P>Never mind...I just found it in F1 --&gt; Chart aggregate functions.</P><P>=FirstSortedValue(Balance,-[Serial No],1)</P><P>Thanks! </P></BODY></HTML> Tue, 24 Feb 2015 08:14:59 GMT 2015-02-24T08:14:59Z Identify last 'Balance' value in Line Chart for a given day https://community.qlik.com/t5/QlikView/Identify-last-Balance-value-in-Line-Chart-for-a-given-day/m-p/777278#M275495 <HTML><HEAD></HEAD><BODY><P><BR />Hello,</P><P>I want to achieve the following scenario in Line Chart (and not in script) -</P><P>Scenario - In a given date of a month there can be more than one transaction. For example, a bank account may undergo several debits and single credit on a given date. This changes the Balance for that account, multiple times, for that day. How will then I identify the last balance value for that date, i.e,&nbsp; 'last balance amount'??</P><P>Please find the attached .xls file having sample data set ---&gt; I need 44,982.98 as my last Balance value on 01/01/2014 to be shown as data point in Line Chart (using some expression)</P><P></P><P>Thanks,</P><P>Abhishek</P></BODY></HTML> Tue, 24 Feb 2015 07:45:10 GMT https://community.qlik.com/t5/QlikView/Identify-last-Balance-value-in-Line-Chart-for-a-given-day/m-p/777278#M275495 2015-02-24T07:45:10Z Re: Identify last 'Balance' value in Line Chart for a given day https://community.qlik.com/t5/QlikView/Identify-last-Balance-value-in-Line-Chart-for-a-given-day/m-p/777279#M275496 <HTML><HEAD></HEAD><BODY><P>Never mind...I just found it in F1 --&gt; Chart aggregate functions.</P><P>=FirstSortedValue(Balance,-[Serial No],1)</P><P>Thanks! </P></BODY></HTML> Tue, 24 Feb 2015 08:14:59 GMT https://community.qlik.com/t5/QlikView/Identify-last-Balance-value-in-Line-Chart-for-a-given-day/m-p/777279#M275496 2015-02-24T08:14:59Z