Set Analysis using complex variable syntax

marc_wintjen — Thu, 09 Aug 2012 22:24:24 GMT

1. I have a complex Chart that references multiple variables to derive values.

2. The current chart calcuates the "% Product Lock Variance" accrurately by Plan which is stored as a variable called "vProductLockDelta".

3. The goal is to take that derived value from "vProductLockDelta" by Plan and then lookup up the equalilant Score in the "Lookup Table".

4. When I try to reference that variable result in a set analysis expression, it does not calculate the value for each specific Plan, rather just 1 value for all plans

"=avg({ $< [% Product Lock]= {$(=$(vProductLockDelta))} > } Score)"

5. I've tried multiple variations to the above syntax but this is the only way I return values.

Is there a way for the Set Analysis expression to return back the correct Score for the "% Product Lock Variance" for each row in the above chart?

Thanks in advance for your help!

Marc

Re: Set Analysis using complex variable syntax

marc_wintjen — Fri, 10 Aug 2012 14:48:58 GMT

Rather than reference a variable - Does anyone know if you can reference the result of a calculated column in Set Analysis? Something like:

"=avg({ $< [% Product Lock]= {$(=$(column(3)))} > } Score)"

Thanks,

Marc

topic Set Analysis using complex variable syntax in QlikView

Set Analysis using complex variable syntax

Re: Set Analysis using complex variable syntax