Set Analysis

[qv_testing]

Hi all,

I have 1990,1991,1992,1993

i want to display only 1990, 1991 and 1993.

Thanks...

[jagan]

Hi,

In expression just write the following expression

Sum({<Year={1990, 1991,1993}>} MeasureName)

Hope this helps you.

Regards,

Jagan.

[qv_testing]

Hi Jagan,

Suppose if i have 100 records,

[jagan]

Hi,

Just hard code the values in the expression, or arrive a field with flag so that we can exclude based on the flag value.

LOAD

     If(Match(Year, 1990, 1991, 1992, 1993,.................................), 1, 0) AS Flag,

     *

FROM DataSource;

And use the expression below

=Sum({<Flag={1}>} MeasureName)

Regards,

Jagan.

[nizamsha · Accepted solution]

try this

sum({$<year={1990,1991,1993}>}fieldname)

or   this

=sum({$<Year={"*"},Year-={'1992'}>}fieldname)

[brijesh1991]

Tab1:

Load *,

if(MixMatch(Year,'1990', '1991','1993'),1,0) as Flag

from Table;

Tab2:

Load * resident Tab1 where Flag=1;

drop table Tab1;