Set Analysis in QlikView - value for previous year

[lukas_sokol]

Hi,

I have the following problem

I want to have sum of OrderValue only when orderqty 2013,2014 and orderValue 2013,2014 is <> 0

I try:

if(

    Sum({$< Year ={$(PrevYear)} >}OrderedQty) <> 0 and

    Sum({$< Year ={$(PrevYear)} >}OrderValue) <> 0 and

    sum( {$<Flag_OrderValue = {1}>} OrderedQty) <> 0 and

    Sum( {$<Flag_OrderValue = {1}>} OrderValueBase) <> 0,

     Sum(OrderValue)

  )

[lukas_sokol]

using

sum(AGGR(YourExpression,Dimension1,Dim2,Dim3)) give to correct value