Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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

MA

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

try with

If(IsNull(

Before(ProductionContribution,1)

) ....

View solution in original post

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

try with

If(IsNull(

Before(ProductionContribution,1)

) ....

Anonymous
Not applicable
Author

thanks so much!