topic Problem with set Analysis. in QlikView

Problem with set Analysis.

Wed, 20 Jul 2011 02:24:29 GMT

My Expression :

=Avg({<flag={'OriginScore'},KPI=,Month={"<=6"}>}Score)

It work fine

however i want to replace number 6 with only(Month)

=Avg({<flag={'OriginScore'},KPI=,Month={"<=only(Month)"}>}Score)

it fail to produce the result.

did anyone can help ?

Re: Problem with set Analysis.

mike_garcia — Wed, 20 Jul 2011 02:28:18 GMT

You need to use Dollar-Sign Expansion for the Expression to be evaluated.

Try:

=Avg({<flag={'OriginScore'},KPI=,Month={"<=$(=only(Month))"}>}Score)

Mike.

Problem with set Analysis.

Wed, 20 Jul 2011 03:32:35 GMT

i tried but it not working .It seem that i can't use expression inside " "

Re: Problem with set Analysis.

mike_garcia — Wed, 20 Jul 2011 04:09:20 GMT

In order to use the Only() function you must have only one possible (or selected) value in the Month field. If you have more than one selected value, you need to discriminate among them, by using the Max function, for instance.

Assuming the Field Month has numeric values, or values that have a numeric representation, you can try:

=Avg({<flag={'OriginScore'},KPI=,Month={"<=$(=Max(Month))"}>}Score)

Mike.