topic Set Expression in QlikView

Set Expression

Fri, 02 Mar 2012 05:56:33 GMT

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

Re: Set Expression

sridhar240784 — Fri, 02 Mar 2012 06:00:54 GMT

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

Re: Set Expression

CELAMBARASAN — Fri, 02 Mar 2012 06:05:05 GMT

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