Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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. 

Labels (2)
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!