topic Re: Set Analysis in QlikView

Set Analysis

bobbydave — Wed, 25 Nov 2020 16:16:04 GMT

I am wondering what is wrong with this.

Service is made up of groups.

I am trying to break it down and don't want X and Y to be part of group and when eliminated, I then want the Service to show what I have left in the group.

=sum( {<
if(Group <> 'X', if(Group <> 'Y', Group)) >}

TV_Number

)

Re: Set Analysis

MindaugasBacius — Fri, 20 May 2016 09:01:11 GMT

Try this:

Sum({<
    Group -={'X', 'Y'}
>}
TV_Number)

Re: Set Analysis

pooja_sn — Fri, 20 May 2016 09:05:27 GMT

sum({<Group -={ 'X', 'Y'}>}TV_Number)

Re: Set Analysis

ankit777 — Fri, 20 May 2016 09:05:38 GMT

Try this

sum({<Group-={'X','Y'}>TV_Number}

Re: Set Analysis

Kushal_Chawda — Fri, 20 May 2016 09:05:41 GMT

try

=sum( {<Group-={'x','Y'} >} TV_Number)

its better to create the Flag In script.

if(not match(Group,'X','Y'),1,0) as FlagGroup

then write set analysis like below

=sum( {<FlagGroup={'1'} >} TV_Number)

Re: Set Analysis

Kushal_Chawda — Fri, 20 May 2016 09:08:54 GMT

Re: Set Analysis

CELAMBARASAN — Fri, 20 May 2016 09:15:51 GMT

You have to write anyone like below

=sum(

if(not Match(Group , 'X','Y'),

TV_Number)

)

Prefer to use below Set Analysis expression

=sum( {<Group-={'X', 'Y'}>}

TV_Number

)