Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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!