Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
mahinkle
New Contributor III

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

Tags (2)
1 Solution

Accepted Solutions

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

try with

If(IsNull(

Before(ProductionContribution,1)

) ....

View solution in original post

2 Replies

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

try with

If(IsNull(

Before(ProductionContribution,1)

) ....

View solution in original post

mahinkle
New Contributor III

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

thanks so much!