topic Re: How to find the total of my current selection year in QlikView https://community.qlik.com/t5/QlikView/How-to-find-the-total-of-my-current-selection-year/m-p/888660#M532916 <HTML><HEAD></HEAD><BODY><P>Could you give more details about your data set?</P></BODY></HTML> Thu, 23 Apr 2015 05:04:54 GMT robert_mika 2015-04-23T05:04:54Z How to find the total of my current selection year https://community.qlik.com/t5/QlikView/How-to-find-the-total-of-my-current-selection-year/m-p/888659#M532915 <HTML><HEAD></HEAD><BODY><P>Dear friends,</P><P>&nbsp;&nbsp; How can I find the total of sale value in a current selection of year</P><P>Eg:</P><P>Sales of value in 2003 incase if I change the year into 2004 it will automatically change itself</P><P></P><P>Pls send it an expression</P></BODY></HTML> Thu, 23 Apr 2015 05:02:33 GMT https://community.qlik.com/t5/QlikView/How-to-find-the-total-of-my-current-selection-year/m-p/888659#M532915 2015-04-23T05:02:33Z Re: How to find the total of my current selection year https://community.qlik.com/t5/QlikView/How-to-find-the-total-of-my-current-selection-year/m-p/888660#M532916 <HTML><HEAD></HEAD><BODY><P>Could you give more details about your data set?</P></BODY></HTML> Thu, 23 Apr 2015 05:04:54 GMT https://community.qlik.com/t5/QlikView/How-to-find-the-total-of-my-current-selection-year/m-p/888660#M532916 robert_mika 2015-04-23T05:04:54Z Re: How to find the total of my current selection year https://community.qlik.com/t5/QlikView/How-to-find-the-total-of-my-current-selection-year/m-p/888661#M532917 <HTML><HEAD></HEAD><BODY><P>I have detail like as below</P><P>year&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; salesvalue</P><P>2001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4563878.12</P><P>2003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 78945.123</P><P>2005&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 789456</P><P>.2002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5487961.32</P><P>2001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 896564.2</P><P>2003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4565832.1</P><P>2005&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 54879386.1</P><P></P><P>And I need total no of sales value for a particular year. if I select 2001 means it will reply the total of sales value from 2001 if I click 2003 means It returns total value of 2003</P><P></P><P>That's is it . I need this result in an expression...</P></BODY></HTML> Thu, 23 Apr 2015 05:14:08 GMT https://community.qlik.com/t5/QlikView/How-to-find-the-total-of-my-current-selection-year/m-p/888661#M532917 2015-04-23T05:14:08Z Re: How to find the total of my current selection year https://community.qlik.com/t5/QlikView/How-to-find-the-total-of-my-current-selection-year/m-p/888662#M532918 <HTML><HEAD></HEAD><BODY><P>And more over I used this simple exp.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =sum([Sale value])</P><P>It perform correctly but i want to know there is&nbsp; any other exp available for this scenario to make it more efficiently tat y am asking.......</P></BODY></HTML> Thu, 23 Apr 2015 05:17:45 GMT https://community.qlik.com/t5/QlikView/How-to-find-the-total-of-my-current-selection-year/m-p/888662#M532918 2015-04-23T05:17:45Z Re: How to find the total of my current selection year https://community.qlik.com/t5/QlikView/How-to-find-the-total-of-my-current-selection-year/m-p/888663#M532919 <HTML><HEAD></HEAD><BODY><P>sum(salesvalue) should work</P><P><IMG alt="2015-04-23 06_20_44-QlikView Personal Edition - [C__Users_Katarzyna_Desktop_161310.qvw_].png" class="jive-image image-1" src="/legacyfs/online/84391_2015-04-23 06_20_44-QlikView Personal Edition - [C__Users_Katarzyna_Desktop_161310.qvw_].png" style="height: auto;" /></P></BODY></HTML> Thu, 23 Apr 2015 05:23:28 GMT https://community.qlik.com/t5/QlikView/How-to-find-the-total-of-my-current-selection-year/m-p/888663#M532919 robert_mika 2015-04-23T05:23:28Z Re: How to find the total of my current selection year https://community.qlik.com/t5/QlikView/How-to-find-the-total-of-my-current-selection-year/m-p/888664#M532920 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can also write like</P><P></P><P>Sum({&lt;Year={"$(=max(Year))"}&gt;}[Sale Value])</P><P></P><P>By default it will give you result for max(Year) else it will give on selection.</P><P></P><P>Regards</P></BODY></HTML> Thu, 23 Apr 2015 05:25:00 GMT https://community.qlik.com/t5/QlikView/How-to-find-the-total-of-my-current-selection-year/m-p/888664#M532920 PrashantSangle 2015-04-23T05:25:00Z Re: How to find the total of my current selection year https://community.qlik.com/t5/QlikView/How-to-find-the-total-of-my-current-selection-year/m-p/888665#M532921 <HTML><HEAD></HEAD><BODY><P>'KISS' is the best way..;)</P><P>(google KISS)</P></BODY></HTML> Thu, 23 Apr 2015 05:27:18 GMT https://community.qlik.com/t5/QlikView/How-to-find-the-total-of-my-current-selection-year/m-p/888665#M532921 robert_mika 2015-04-23T05:27:18Z Re: How to find the total of my current selection year https://community.qlik.com/t5/QlikView/How-to-find-the-total-of-my-current-selection-year/m-p/888666#M532922 <HTML><HEAD></HEAD><BODY><P>Max I got my expected expression thank you very much</P></BODY></HTML> Thu, 23 Apr 2015 05:37:26 GMT https://community.qlik.com/t5/QlikView/How-to-find-the-total-of-my-current-selection-year/m-p/888666#M532922 2015-04-23T05:37:26Z Re: How to find the total of my current selection year https://community.qlik.com/t5/QlikView/How-to-find-the-total-of-my-current-selection-year/m-p/888667#M532923 <HTML><HEAD></HEAD><BODY><P>Robert u r very helpful to me and am surfing the word 'KISS' in google it&nbsp; give me lot of ideas thank you</P></BODY></HTML> Thu, 23 Apr 2015 05:38:50 GMT https://community.qlik.com/t5/QlikView/How-to-find-the-total-of-my-current-selection-year/m-p/888667#M532923 2015-04-23T05:38:50Z