topic Re: FirstSortedValue in QlikView https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282748#M402074 <HTML><HEAD></HEAD><BODY><P>You can create a variable with the expression of "Last" and then use in the set analysis of the Sum.</P><P>Something like this...</P></BODY></HTML> Tue, 22 Nov 2016 14:49:10 GMT Anonymous 2016-11-22T14:49:10Z Calculate amount of last invoice of each customer before a selected month https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282740#M402066 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>Can someone tell me how the firstsorted value is used?</P><P>I have a pivot table with Customer as dimension</P><P>I want to display for each customer the max InvoiceNumber before this month as well as the calculate the sum of the amount of each of last invoice number</P><P>Please advise</P></BODY></HTML> Mon, 21 Nov 2016 12:08:02 GMT https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282740#M402066 ali_hijazi 2016-11-21T12:08:02Z Re: FirstSortedValue https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282741#M402067 <HTML><HEAD></HEAD><BODY><P>Would you be able to share some raw data with the expected output to help you better? It will be pure guesswork without a sample as its difficult to understand what you are trying to get</P></BODY></HTML> Mon, 21 Nov 2016 12:12:49 GMT https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282741#M402067 sunny_talwar 2016-11-21T12:12:49Z Re: FirstSortedValue https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282742#M402068 <HTML><HEAD></HEAD><BODY><P>check attached document</P><P>Actually I'm trying to find the value of the last invoice of each customer not served in the selected month</P><P>hope you can help me in this</P><P>I'm able to get&nbsp; the customers not served and the maximum invoice before october 2016</P><P>but How I can get the value of the last invoice of each customer not served ; I'm not able to</P><P>please advise</P></BODY></HTML> Mon, 21 Nov 2016 12:25:19 GMT https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282742#M402068 ali_hijazi 2016-11-21T12:25:19Z Re: FirstSortedValue https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282743#M402069 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P>Let me know!</P></BODY></HTML> Mon, 21 Nov 2016 16:48:03 GMT https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282743#M402069 Anonymous 2016-11-21T16:48:03Z Re: FirstSortedValue https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282744#M402070 <HTML><HEAD></HEAD><BODY><P>your document doesn't open it gives the following error</P><P><IMG alt="not_opening.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144498_not_opening.png" style="height: auto;" /></P></BODY></HTML> Tue, 22 Nov 2016 12:02:11 GMT https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282744#M402070 ali_hijazi 2016-11-22T12:02:11Z Re: FirstSortedValue https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282745#M402071 <HTML><HEAD></HEAD><BODY><P>I dont' not why.</P><P>Maybe this one?</P></BODY></HTML> Tue, 22 Nov 2016 12:36:46 GMT https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282745#M402071 Anonymous 2016-11-22T12:36:46Z Re: FirstSortedValue https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282746#M402072 <HTML><HEAD></HEAD><BODY><P>Just as a confirmation, I was able to open both the qvws attached by <A href="https://community.qlik.com/people/elena888">elena888</A>‌</P></BODY></HTML> Tue, 22 Nov 2016 12:50:07 GMT https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282746#M402072 sunny_talwar 2016-11-22T12:50:07Z Re: FirstSortedValue https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282747#M402073 <HTML><HEAD></HEAD><BODY><P>here you got the invoice number what I want is to calculate the sales amount where invoice number is the one you got</P><P>How can I get the invoice number in set analysis?</P><P>i.e. sum of valueusd where invoice is the last one for each customer I have</P></BODY></HTML> Tue, 22 Nov 2016 14:24:40 GMT https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282747#M402073 ali_hijazi 2016-11-22T14:24:40Z Re: FirstSortedValue https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282748#M402074 <HTML><HEAD></HEAD><BODY><P>You can create a variable with the expression of "Last" and then use in the set analysis of the Sum.</P><P>Something like this...</P></BODY></HTML> Tue, 22 Nov 2016 14:49:10 GMT https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282748#M402074 Anonymous 2016-11-22T14:49:10Z Re: FirstSortedValue https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282749#M402075 <HTML><HEAD></HEAD><BODY><P>No no</P><P>you created the variable with an equal sign at the beginning</P><P>and this will give the sum for one invoice number which is the max</P><P>what I want is to calculate the sum for the last invoice of each customer not one only last Invoice as in your suggestion</P></BODY></HTML> Tue, 22 Nov 2016 17:10:34 GMT https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282749#M402075 ali_hijazi 2016-11-22T17:10:34Z Re: Calculate amount of last invoice of each customer before a selected month https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282750#M402076 <HTML><HEAD></HEAD><BODY><P>Any other suggestions?!</P></BODY></HTML> Tue, 22 Nov 2016 18:31:22 GMT https://community.qlik.com/t5/QlikView/Calculate-amount-of-last-invoice-of-each-customer-before-a/m-p/1282750#M402076 ali_hijazi 2016-11-22T18:31:22Z