Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

need help with straight table expression

Hi,

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.

1 Reply
thomas_skariah
Contributor III

Re: need help with straight table expression

Hi Ram,

Not sure about your point,is it like you need Curent year current month vs previous year previous month?

Regards,

Tom

Community Browser