topic Help With Set Analysis in QlikView

Help With Set Analysis

Thu, 26 Aug 2010 14:24:51 GMT

Hi Please help

why do I get an error with this syntax =AVG(IF(DASHMEASURE_SK=11,({$<MEASUREDIMENTION3=>}MEASUREDIMENSION1)))

i AM TRYING TO EXCLUDE MEASUREDIMENTION3 FROM MY SELECTIONS

Help With Set Analysis

Thu, 26 Aug 2010 14:34:05 GMT

I'm not sure what you need, but it can be like this:


=AVG( {$<MEASUREDIMENTION3=, DASHMEASURE_SK={11}>} MEASUREDIMENSION1)

It means that for all current selections for ALL (regardless of current selections for MEASUREDIMENTION3) MEASUREDIMENTION3 and DASHMEASURE_SK=11derive AVG() of MEASUREDIMENSION1

Help With Set Analysis

Thu, 26 Aug 2010 14:44:59 GMT

Hi Nick

Thanks for the feedback, I wish to derive the avg() of MeasureDimension1 for all current selections except MeasureDimention3

Help With Set Analysis

Thu, 26 Aug 2010 14:51:31 GMT

Explain a condition for "except MeasureDimention3" then.

Help With Set Analysis

Fri, 27 Aug 2010 09:49:55 GMT

MeasureDimention3 is one of the selections, I want it excluded from the calculation

Help With Set Analysis

Fri, 27 Aug 2010 13:25:34 GMT

Still don't get it. You are selecting some data in MeasureDimention3 and you want to calculate all the data but for all others, that is exclusion for the MeasureDimention3 for the field itself, right?

if it's correct, then you can use this:

<pre>=AVG( {$<MEASUREDIMENTION3=e(), DASHMEASURE_SK={11}>} MEASUREDIMENSION1)

Help With Set Analysis

Fri, 27 Aug 2010 14:29:29 GMT

Nick my friend you are a star, that is exactly what I needed