Set Analysis on basis of a If condition

[amijit_hazarika]

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]) 

[pooja_prabhu_n]

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]))