Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
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]))