how to write expression for rolling dimension?

Wed, 11 Apr 2012 06:26:56 GMT

Hi,

I have the following requirement :- there r 7 dimensions namely- month , raw material,job,work center,commodity,plant ,zone and three expressions namely standard cost, planned cost, budget cost . i need to create the pivot table for these , the expression for standard cost is

if isnull({actual_cost})or

isnull({actual_qty})

then 0

else {actual_cost} * {actual_qty}

Also the expressions should have 12 months rolling period . i.e. if i click on 2011 dec then data should get displayed for 12 months from dec 2010 till dec 2011.

Help me with the expression.....

how to write expression for rolling dimension?

jagan — Wed, 11 Apr 2012 08:34:14 GMT

Hi,

Use this expression

=Sum({<DateFieldName={'>=$(MonthStart(Max(DateFieldName), -12)) <=$(MonthEnd(Max(DateFieldName))) '}>} Alt(actual_cost, 0) * Alt(actual_qty, 0))

Hope this helps you.

Regards,

Jagan.

topic how to write expression for rolling dimension? in QlikView

how to write expression for rolling dimension?

how to write expression for rolling dimension?