topic Re: Expression for summarizing categories in QlikView https://community.qlik.com/t5/QlikView/Expression-for-summarizing-categories/m-p/407935#M1155535 <HTML><HEAD></HEAD><BODY><P>See attached qvw for two solutions.</P></BODY></HTML> Sat, 30 Mar 2013 09:39:42 GMT Gysbert_Wassenaar 2013-03-30T09:39:42Z Expression for summarizing categories https://community.qlik.com/t5/QlikView/Expression-for-summarizing-categories/m-p/407934#M1155534 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the following data in my model already (sample):</P><P></P><P>ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AddedOn&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FinishedBy</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sprint1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sprint3</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sprint1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sprint1</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sprint2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sprint3</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sprint2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sprint2</P><P>5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sprint2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sprint2</P><P>6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sprint2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sprint3</P><P>7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sprint3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sprint3</P><P></P><P>and I want to be able to put it in a table like below:</P><P></P><P>Sprint&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; No. of New/Additions&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; No. of Finished</P><P>Sprint1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>Sprint2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>Sprint3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P></P><P>How should I formulate the expression of my table/chart?</P><P></P><P>Thanks!</P><P>&gt;Ronald</P></BODY></HTML> Sat, 30 Mar 2013 04:09:02 GMT https://community.qlik.com/t5/QlikView/Expression-for-summarizing-categories/m-p/407934#M1155534 2013-03-30T04:09:02Z Re: Expression for summarizing categories https://community.qlik.com/t5/QlikView/Expression-for-summarizing-categories/m-p/407935#M1155535 <HTML><HEAD></HEAD><BODY><P>See attached qvw for two solutions.</P></BODY></HTML> Sat, 30 Mar 2013 09:39:42 GMT https://community.qlik.com/t5/QlikView/Expression-for-summarizing-categories/m-p/407935#M1155535 Gysbert_Wassenaar 2013-03-30T09:39:42Z Re: Expression for summarizing categories https://community.qlik.com/t5/QlikView/Expression-for-summarizing-categories/m-p/407936#M1155536 <HTML><HEAD></HEAD><BODY><P>Thanks Gysbert! I should have figured to try using If. I am leaning more on using the solution using If as the number of sprints can grow.</P><P></P><P>Thanks again!</P></BODY></HTML> Sat, 30 Mar 2013 16:13:15 GMT https://community.qlik.com/t5/QlikView/Expression-for-summarizing-categories/m-p/407936#M1155536 2013-03-30T16:13:15Z Re: Expression for summarizing categories https://community.qlik.com/t5/QlikView/Expression-for-summarizing-categories/m-p/407937#M1155537 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I know you already got the solution, but still find the attched this one.</P><P></P><P>Regards,</P><P>Kush</P></BODY></HTML> Mon, 01 Apr 2013 07:04:57 GMT https://community.qlik.com/t5/QlikView/Expression-for-summarizing-categories/m-p/407937#M1155537 Kushal_Chawda 2013-04-01T07:04:57Z