topic Re: exclude some data with set analysis in QlikView

exclude some data with set analysis

kamal_sanguri — Mon, 20 Apr 2015 20:04:29 GMT

Hi All,

I am stuck in a situation where I need to exclude some data with set analysis.

Please check attached QVW for more information.

Thanks,

Kamal

Re: exclude some data with set analysis

maxgro — Mon, 20 Apr 2015 20:19:11 GMT

if(GetPossibleCount([service family])>1, sum(cost),

if([service family]='server',

sum({$ <[Service category]=E({$ <[service family]={mainframe}>} [Service category])>} cost),

sum(cost)

))

Re: exclude some data with set analysis

kamal_sanguri — Mon, 20 Apr 2015 20:25:32 GMT

Thanks for the help... I am sorry I could not clear the situation..

If both the items (Mainframe and server) are selected I need to have sum of all mainframe items and those items of server where service category is not alredy there in mainframe..

i.e the sum of items which I see when I select mainframe and server items which I see when I select server.

Thanks,

Re: exclude some data with set analysis

b_garside — Mon, 20 Apr 2015 20:45:57 GMT

To exclude use a minus equals -= syntax;

Field-={"Value"} Not equal

Field={"Value"} must equal

Or use E() as post above suggested.

Re: exclude some data with set analysis

maxgro — Mon, 20 Apr 2015 20:49:36 GMT

if(GetPossibleCount([service family])>1,

sum({$ <[Service category]=E({$ <[service family]={mainframe}>} [Service category])>+<[service family]={mainframe}>} cost),

if([service family]='server',

sum({$ <[Service category]=E({$ <[service family]={mainframe}>} [Service category])>} cost),

sum(cost)

))