Set Expression

[#1]

Hi,

=NumericCount ( {<[Flag] = {"1"} ,YEAR={"*"},QTR=,Month,Week=>} Score)

I have gone through a set expression like above. Can anyone please explain the result of above regarding the role of QTR, Month and Week? What does their presence above indicate?

Thanks,

Murali

[sridhar240784]

This QTR=,Month=,Week= in this expression ignore the user selections for QTR, Month, Week fields meaning to say your data will not chnage in the grap, if you select any thing from QTR,Month & Week Field.

-Sridhar

[CELAMBARASAN · Accepted solution]

Hi,

     It selects the Flag field has value 1.

     Year={'*'} means to consider all years but excludes null values.

     QTR= means to exclude selection and it consider all values in the QTR field.likewise Month=,Week= fields.

Celambarasan