topic Re: need help with straight table expression in QlikView https://community.qlik.com/t5/QlikView/need-help-with-straight-table-expression/m-p/429890#M569665 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hi Ram,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Not sure about your point,is it like you need Curent year current month vs previous year previous month?</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Regards,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Tom</SPAN></P></BODY></HTML> Fri, 19 Oct 2012 01:45:25 GMT thomas_skariah 2012-10-19T01:45:25Z need help with straight table expression https://community.qlik.com/t5/QlikView/need-help-with-straight-table-expression/m-p/429889#M569664 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In straight table i am using expression </P><P></P><P>sum(InMonth(PeriodDate,setdateyearmonth('2000-01-01', vNextYearToSelected, 01) ,0,0) * -1 * [Actual] * Sign)</P><P></P><P>to calculate the sum of Actual amount for January month, where vNextYearToSelected = 2012 and PeriodDate have values from Apr-2011 to Jun-2012.</P><P>And actual selected year is 2011. </P><P>Straight table is showing the data for all 12 months (Apr to Mar 12 columns) based on the year selection.</P><P>Somehow this expression is not giving the right result, is there any modification required, please help me.</P></BODY></HTML> Thu, 18 Oct 2012 16:31:08 GMT https://community.qlik.com/t5/QlikView/need-help-with-straight-table-expression/m-p/429889#M569664 2012-10-18T16:31:08Z Re: need help with straight table expression https://community.qlik.com/t5/QlikView/need-help-with-straight-table-expression/m-p/429890#M569665 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hi Ram,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Not sure about your point,is it like you need Curent year current month vs previous year previous month?</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Regards,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Tom</SPAN></P></BODY></HTML> Fri, 19 Oct 2012 01:45:25 GMT https://community.qlik.com/t5/QlikView/need-help-with-straight-table-expression/m-p/429890#M569665 thomas_skariah 2012-10-19T01:45:25Z