If Before xx = (not there) do this....

Anonymous — Thu, 12 Feb 2015 13:32:10 GMT

On the first column using a Before there would be no value. In this case, i want to do a different calculation but I cant determine how to check if there is nothing 'before'. Any clues?

If (Before(ProductionContribution,1) = (there is no before row.... how do I say this in an If statement)

,((([Prod Prior To WAH]) - ProductionContribution) / [Prod Prior To WAH]),

((Before(ProductionContribution,1) - ProductionContribution) / Before(ProductionContribution,1))

)

Thanks

Re: If Before xx = (not there) do this....

alexandros17 — Thu, 12 Feb 2015 13:33:55 GMT

try with

If(IsNull(

Before(ProductionContribution,1)

) ....

Re: If Before xx = (not there) do this....

Anonymous — Thu, 12 Feb 2015 13:51:20 GMT

thanks so much!

topic If Before xx = (not there) do this.... in QlikView

If Before xx = (not there) do this....

Re: If Before xx = (not there) do this....

Re: If Before xx = (not there) do this....