Need help on if Condition

[abubakarsiddiq7]

hi,

I have a requirement like 

i need calculate the bonus when Service=Customer,Emailflag='y', Threshold='Y'  then we need to calculate the bonus((permance-minvalue)*0.15) else we should show 0.00. i am implementing this requirement in table box in qlik sense 

nov2019 release.

i am using the below if condition but it is working when i am sleeting the appropriate fields 

if(Service=Customer and Emailflag='y'and  Threshold='Y' ,$(Bonus),'0.00')

Thanks,

[tresesco]

There could be many reasons why it is not working, it could be granularity; it could be the expression itself;...best way to quick resolution - try to share a sample app to work on. In the mean time, try like:

 Sum ( if(Service=Customer and Emailflag='y'and  Threshold='Y' ,$(Bonus), 0 ) )

[abubakarsiddiq7]

sum(if( Service='Customer' and EmailFlag='Y' and Threshold='Y',(((sum(NetAmount)/sum(TotalTicketCount)*100)-40)*0.15),'0.00'))

This above expression is giving error message like Nested aggr is not allowed ?

what's wrong here ?