Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
danaleota1
Creator
Creator

Chart expression using multiple modifiers

I'd like to add multiple modifiers to my chart expression.  This is what I have currently

=Count({$< txtValidError = {'Yes'}>} txtCoachingErrorType)/Sum(ACDCALLS)

which is fine but when I try to add additional modifiers I get an error for example I tried- 

=Count({$< txtValidError = {'Yes'}> +$ <txtSegment <> {'eServices'}>}  txtCoachingErrorType)/Sum(ACDCALLS)

I want to return only the Count(txtCoachingErrorType) where txtValidError = 'Yes', txtSegment <> 'eServices',  txtCallInfoType <> 'Compliment' AND txtCallInfoType <> 'Complaint'  , then divide by sum(ACDCALLS).   I'm trying to do this as a chart expression and save as a master item.   Not sure what I'm missing thank you. 

1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

This is a syntax issue.
Try this:
=Count({$< txtValidError = {Yes}, txtSegment =- {eServices}, txtCallInfoType =- {Compliment, Complaint} >} txtCoachingErrorType)/Sum(ACDCALLS)

View solution in original post

2 Replies
Lisa_P
Employee
Employee

This is a syntax issue.
Try this:
=Count({$< txtValidError = {Yes}, txtSegment =- {eServices}, txtCallInfoType =- {Compliment, Complaint} >} txtCoachingErrorType)/Sum(ACDCALLS)

danaleota1
Creator
Creator
Author

Thank you!