Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
amijit_hazarika
Contributor III
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]) 

1 Reply
pooja_prabhu_n
Creator III
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]))