topic Replacing Before() function in QlikView

Replacing Before() function

Thu, 25 Jul 2013 01:48:03 GMT

Hello guys, is there any other function to use which applies the same function as Before() function but will not display null value?

rwunderlich — Thu, 25 Jul 2013 02:35:56 GMT

In the before function, use an expression (like RangeSum) that does not return null values. Like:

=before(RangeSum(Sales))

-Rob

Thu, 25 Jul 2013 03:01:46 GMT

It dont work. Take a look at my code?

=if( Before( Sum (IF(Status <> 'SINGLE' and GUYS>=0, GUYS,0)) , 0) = 0

OR IsNull( Before( Sum (IF(Status <> 'SINGLE' and GUYS>=0, GUYS,0)) , 0)) = -1, null(),

if( MonthLast( MAX( Date ) ) <> var_LastDate AND MonthLast( MAX ( Date ) )

= MonthLast( var_LastDate ) ,

Sum( IF(Status = 'ATTACHED', GUYS,0)) / Day( var_LastDate ) * Day(MonthLast( MAX ( Date ) )) ,

Sum( IF(Status = 'ATTACHED', GUYS,0) ))

- Before(Sum(IF(Status = 'ATTACHED',GUYS,0)) , 1 )

)

Kushal_Chawda — Thu, 25 Jul 2013 04:30:33 GMT

ty this,

f( Before( Sum (IF(Status <> 'SINGLE' and GUYS>=0, GUYS,0)) , 0) = 0

OR IsNull( Before( Sum (IF(Status <> 'SINGLE' and GUYS>=0, GUYS,0)) , 0)) = -1, 0,

if( MonthLast( MAX( Date ) ) <> var_LastDate AND MonthLast( MAX ( Date ) )

= MonthLast( var_LastDate ) ,

rangesum(Sum( IF(Status = 'ATTACHED', GUYS,0)) / Day( var_LastDate ) * Day(MonthLast( MAX ( Date ) ))) ,

rangesum(Sum( IF(Status = 'ATTACHED', GUYS,0) ))

- Before(Sum(IF(Status = 'ATTACHED',GUYS,0)) , 1 ))

)

Thu, 25 Jul 2013 05:32:20 GMT

It still give me null value 😐