topic Re: how to take difference of time period in dimension in QlikView https://community.qlik.com/t5/QlikView/how-to-take-difference-of-time-period-in-dimension/m-p/364149#M574060 <HTML><HEAD></HEAD><BODY><P>Thanks a lot perumai..</P></BODY></HTML> Tue, 24 Jul 2012 12:20:18 GMT 2012-07-24T12:20:18Z how to take difference of time period in dimension https://community.qlik.com/t5/QlikView/how-to-take-difference-of-time-period-in-dimension/m-p/364145#M574052 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I am stuck at a position in my project development..I have data in the format below:-</P><P></P><P></P><P>Quarters&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp; C</P><P>&nbsp;&nbsp; Q1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</P><P>&nbsp;&nbsp; Q2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>&nbsp;&nbsp;&nbsp; Q3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp; 13</P><P>&nbsp;&nbsp; Q4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P></P><P></P><P>and i need chart and table in the format as:-</P><P></P><P>Quarters&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; X&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Z</P><P>&nbsp;&nbsp;&nbsp; Q2-Q1&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; -</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Q3-Q2&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; -</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Q4-Q3&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; -</P><P></P><P>How do i solve this problem? </P></BODY></HTML> Tue, 24 Jul 2012 06:15:35 GMT https://community.qlik.com/t5/QlikView/how-to-take-difference-of-time-period-in-dimension/m-p/364145#M574052 2012-07-24T06:15:35Z Re: how to take difference of time period in dimension https://community.qlik.com/t5/QlikView/how-to-take-difference-of-time-period-in-dimension/m-p/364146#M574053 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>in Expression side use this expression </P><P></P><P>=below(Sum(Value)-Sum(Value)</P><P></P><P>.Try thsi expression</P><P>Regards</P><P>Perumal A</P></BODY></HTML> Tue, 24 Jul 2012 06:22:57 GMT https://community.qlik.com/t5/QlikView/how-to-take-difference-of-time-period-in-dimension/m-p/364146#M574053 perumal_41 2012-07-24T06:22:57Z Re: how to take difference of time period in dimension https://community.qlik.com/t5/QlikView/how-to-take-difference-of-time-period-in-dimension/m-p/364147#M574055 <HTML><HEAD></HEAD><BODY><P>Check the attached file</P></BODY></HTML> Tue, 24 Jul 2012 06:59:37 GMT https://community.qlik.com/t5/QlikView/how-to-take-difference-of-time-period-in-dimension/m-p/364147#M574055 sivarajs 2012-07-24T06:59:37Z Re: how to take difference of time period in dimension https://community.qlik.com/t5/QlikView/how-to-take-difference-of-time-period-in-dimension/m-p/364148#M574058 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>your expression must be</P><P></P><P>Below(Total Sum(val1))-Sum(val1)</P><P></P><P>Greetings</P><P></P><P>Martina</P></BODY></HTML> Tue, 24 Jul 2012 08:13:19 GMT https://community.qlik.com/t5/QlikView/how-to-take-difference-of-time-period-in-dimension/m-p/364148#M574058 brenner_martina 2012-07-24T08:13:19Z Re: how to take difference of time period in dimension https://community.qlik.com/t5/QlikView/how-to-take-difference-of-time-period-in-dimension/m-p/364149#M574060 <HTML><HEAD></HEAD><BODY><P>Thanks a lot perumai..</P></BODY></HTML> Tue, 24 Jul 2012 12:20:18 GMT https://community.qlik.com/t5/QlikView/how-to-take-difference-of-time-period-in-dimension/m-p/364149#M574060 2012-07-24T12:20:18Z