topic Re: Set Analysis in QlikView

Set Analysis

Nagaraju_KCS — Mon, 15 Jul 2013 10:15:03 GMT

Hi all,

I have 1990,1991,1992,1993

i want to display only 1990, 1991 and 1993.

Thanks...

jagan — Mon, 15 Jul 2013 10:19:00 GMT

Hi,

In expression just write the following expression

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

Hope this helps you.

Regards,

Jagan.

Nagaraju_KCS — Mon, 15 Jul 2013 10:21:12 GMT

Hi Jagan,

Suppose if i have 100 records,

jagan — Mon, 15 Jul 2013 10:23:57 GMT

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 — Mon, 15 Jul 2013 10:28:05 GMT

try this

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

or this

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

brijesh1991 — Mon, 15 Jul 2013 10:59:16 GMT

Tab1:

Load *,

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

from Table;

Tab2:

Load * resident Tab1 where Flag=1;

drop table Tab1;