Discussion Board for collaboration on QlikView Layout & Visualizations.
In straight table i am using expression
sum(InMonth(PeriodDate,setdateyearmonth('2000-01-01', vNextYearToSelected, 01) ,0,0) * -1 * [Actual] * Sign)
to calculate the sum of Actual amount for January month, where vNextYearToSelected = 2012 and PeriodDate have values from Apr-2011 to Jun-2012.
And actual selected year is 2011.
Straight table is showing the data for all 12 months (Apr to Mar 12 columns) based on the year selection.
Somehow this expression is not giving the right result, is there any modification required, please help me.
Not sure about your point,is it like you need Curent year current month vs previous year previous month?