topic Re: Set analysis(Lost Amount) in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-Lost-Amount/m-p/915583#M988318 <HTML><HEAD></HEAD><BODY><P>I think this will do it for you:</P><P>=Sum(x) - Above(Sum(x))</P><P>or</P><P><SPAN style="font-size: 13.3333330154419px;">=Sum(x) - Above(Total Sum(x))</SPAN></P></BODY></HTML> Mon, 27 Jul 2015 07:29:33 GMT jonathandienst 2015-07-27T07:29:33Z Set analysis(Lost Amount) https://community.qlik.com/t5/QlikView/Set-analysis-Lost-Amount/m-p/915582#M988317 <HTML><HEAD></HEAD><BODY><P><BR />Lost Amount:</P><P>i have a data looks like that</P><P>ID&nbsp;&nbsp;&nbsp;&nbsp; Jun-2014&nbsp;&nbsp;&nbsp; May-2014&nbsp; April-2014 .......</P><P></P><P></P><P>Each ID has an ammount in each month-year</P><P>i need to show the evolution in a line chart of lost amount for each month</P><P></P><P>Example</P><P>ID&nbsp;&nbsp;&nbsp;&nbsp; Jun-2014&nbsp;&nbsp;&nbsp; May-2014&nbsp; April-2014 .......</P><P>x&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1500</P><P></P><P>Evolution in a pie chart is</P><P>ID&nbsp;&nbsp;&nbsp;&nbsp; Jun-2014&nbsp;&nbsp;&nbsp; May-2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; April-2014 .......</P><P>x&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (2000-1000)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1500-(2000-1000)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Please help Than you</P></BODY></HTML> Mon, 27 Jul 2015 07:16:43 GMT https://community.qlik.com/t5/QlikView/Set-analysis-Lost-Amount/m-p/915582#M988317 mario-sarkis 2015-07-27T07:16:43Z Re: Set analysis(Lost Amount) https://community.qlik.com/t5/QlikView/Set-analysis-Lost-Amount/m-p/915583#M988318 <HTML><HEAD></HEAD><BODY><P>I think this will do it for you:</P><P>=Sum(x) - Above(Sum(x))</P><P>or</P><P><SPAN style="font-size: 13.3333330154419px;">=Sum(x) - Above(Total Sum(x))</SPAN></P></BODY></HTML> Mon, 27 Jul 2015 07:29:33 GMT https://community.qlik.com/t5/QlikView/Set-analysis-Lost-Amount/m-p/915583#M988318 jonathandienst 2015-07-27T07:29:33Z Re: Set analysis(Lost Amount) https://community.qlik.com/t5/QlikView/Set-analysis-Lost-Amount/m-p/915584#M988319 <HTML><HEAD></HEAD><BODY><P>try like attached </P></BODY></HTML> Mon, 27 Jul 2015 07:34:34 GMT https://community.qlik.com/t5/QlikView/Set-analysis-Lost-Amount/m-p/915584#M988319 sunilkumarqv 2015-07-27T07:34:34Z