topic Set Greater Than another set in QlikView

Set Greater Than another set

Wed, 16 Nov 2011 12:26:01 GMT

Hi,

I'm trying to build a set based on values that are greater than another set. I started with this

Count({$ <QuestionID = {'Q22'}, Q22Benefit2 = {">=55"}>} RespKey)

the value 55 is actually meant to be an average of all scorse across a set of all products. So, I built this into my load script using a field called TBIOverallAverage. the expression became:

Count($ <QuestionID = {'Q22'}, Q22Benefit2 = {">=TBIOverallAverage"}>} RespKey)

This doesn't work.

The actual formula I want to get to is something like:

Count({$ <QuestionID = {'Q22'}, Q22Benefit2 = {">=

Avg({$ QuestionID = {'Q22'}"}>} TOTAL <Country, Wave, TargetGroupID> Q22Benefit2RespKey)"}>} RespKey)

This is supposed to represent the number of RespKey who have a value that is greater that the average of all the values.

Any help would be appreciated.

Regards,

Pete

Set Greater Than another set

swuehl — Wed, 16 Nov 2011 14:00:53 GMT

Maybe like

Count({$ <QuestionID = {'Q22'},

Q22Benefit2 = {"=Q22Benefit2 >=

Avg({$<QuestionID = {'Q22'}"}>} TOTAL <Country, Wave, TargetGroupID> Q22Benefit2RespKey)"}

>} RespKey)

Count({$ <QuestionID = {'Q22'},

Q22Benefit2 = {"=Q22Benefit2 >=

$(=Avg({$<QuestionID = {'Q22'}"}>} TOTAL <Country, Wave, TargetGroupID> Q22Benefit2RespKey))"}

>} RespKey)

Regards,

Stefan

Re: Set Greater Than another set

lironbaram — Wed, 16 Nov 2011 14:16:24 GMT

hei

attch is an example

may be you'll find it helpful