Announcements
cancel
Showing results for
Did you mean:
Contributor III

## Set Analysis on basis of a If condition

Hi Qlik Enthusiast,

Can anyone help me write the below set analysis with the if condition mentioned below that;

sum({<IsRollup={0}>}[Base Revenue])+

sum({<IsRollup = {0}>}[Regulatory Standard Change Revenue])+

sum({<IsRollup = {0}>}[Change Order Revenue])+

sum({<IsRollup = {0}>}[Transaction Special Work Revenue])+

Sum({<IsRollup = {0}>}[Next FY Revenue]))

The above set condition should satisfy the below condition. Any help/guidance would be highly appreciated.

The condition is;

if (([Status] = 'Complete')

and (([Person Status] = 'A')

or (([Persn Status] = 'R'

or [Person Status] = 'T')

and vRoll12Rev <> 0 )  ), [Growth Initiate])

Creator III

Hi,

You can try like below:

=if (([Status] = 'Complete')

and (([Person Status] = 'A')

or (([Persn Status] = 'R'

or [Person Status] = 'T')

and vRoll12Rev <> 0 )  ), Your set expression)

Or

=sum({<IsRollup={0}>}if (([Status] = 'Complete')

and (([Person Status] = 'A')

or (([Persn Status] = 'R'

or [Person Status] = 'T')

and vRoll12Rev <> 0 )  ),[Base Revenue]))

Community Browser