Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
abubakarsiddiq7
Contributor III
Contributor III

Need help on if Condition

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,

2 Replies
tresesco
MVP
MVP

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
Contributor III
Contributor III
Author

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 ?