topic Re: Multiple Expressions with Set Analysis in QlikView

Multiple Expressions with Set Analysis

Thu, 29 Jan 2015 09:26:13 GMT

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])

Re: Multiple Expressions with Set Analysis

jonathandienst — Thu, 29 Jan 2015 09:32:07 GMT

Remove the space between the 1 and the <

HTH

Jonathan

Re: Multiple Expressions with Set Analysis

alexandros17 — Thu, 29 Jan 2015 09:32:36 GMT

unfortunately this part of expression

<[SLA status]={"SLA breached"}>

doesn't work with set analysis because the right element must be a unique value not a field, that is you cannot compare a field (SLA status) with another field SLA Breached in this way but only using an aggregated function on the second field ex. Max([SLA breached])

hope this helps

Re: Multiple Expressions with Set Analysis

Thu, 29 Jan 2015 09:36:16 GMT

Thanks for your response Jonathan, but unfortunately it doesn't solve the issue.

Re: Multiple Expressions with Set Analysis

Thu, 29 Jan 2015 09:37:52 GMT

Thank you very much for you response Alessandro.

"SLA Breached" is not a field. It's a possible value for the field [SLA Status]. Hope Im making sense.

Re: Multiple Expressions with Set Analysis

alexandros17 — Thu, 29 Jan 2015 09:42:42 GMT

You're right, sorry, I didn't notice the apex, in this case the syntax seems correct (Only try to replace double with single quotes " with ')

if it doesn't work take a look to data ...

(I suggest to create a flat table, then show all values)

Re: Multiple Expressions with Set Analysis

Thu, 29 Jan 2015 09:47:25 GMT

I've tried to use single quotes. Still no difference.

Re: Multiple Expressions with Set Analysis

Thu, 29 Jan 2015 09:52:01 GMT

For the first expression.... If I remove the second part (where I want to subtract), it works fine.

Re: Multiple Expressions with Set Analysis

morganaaron — Thu, 29 Jan 2015 09:57:19 GMT

Does the second expression work?

Re: Multiple Expressions with Set Analysis

Thu, 29 Jan 2015 10:03:13 GMT

HI Aaron.

The second expression works perfectly.

I notice, that if I change the minus sign to a plus ( + ) or multiply ( * ) or divide ( / ), then it works. BUt for the minus, it just gives me NOTHING . I don't know if that carries some significance to the issue.

Re: Multiple Expressions with Set Analysis

morganaaron — Thu, 29 Jan 2015 10:15:14 GMT

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?

Re: Multiple Expressions with Set Analysis

Thu, 29 Jan 2015 12:59:15 GMT

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