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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple Expressions with Set Analysis

Hi there

I need to have set analysis on two expressions in my chart.  BUt it's not working.  Please help?

At the moment it looks like this.....

Expression 1 (Open) :

Count({1 <Active={"Open"}>} [Helpdesk number])  - Count({1 <[SLA status]={"SLA breached"}> }[Helpdesk number])

Expression 2 (Open Breached) :

Count({1<[SLA status]={"SLA breached"}> } [Helpdesk number])

11 Replies
morganaaron
Specialist
Specialist

Bizarre.

I've uploaded an app I threw together to recreate the idea and it works fine. I've got expressions there that subtract all breached from open (regardless of it's active status) and also an expression that subtracts all breached that are also open. Does your syntax checker throw up any issues?

Not applicable
Author

This is helping a lot Aaron.  I just to fine tune it a bit....