topic Re: Set analysis in QlikView

Set analysis

0li5a3a — Fri, 25 Aug 2017 09:34:55 GMT

Hi All,

I would like to use set analysis to do some calculations.

First calculation:

I need to count the total of incidents where the creator group is the same like the resolve group.

i used this :

=count({<CREATORGROUP = {'Intern'} ,RESOLVEDGROUP ={'Intern'}>}Incident)

Could someone confirm if this is right or no, because is looking that is not right.

Second calculation:

I want to count the total of incidents where the creator group is different then resolve group.

i tried this:

=count({<CREATORGROUP = {'Intern'} <> RESOLVEDGROUP ={'Intern'}>}Incident)

Regards,

Re: Set analysis

sunny_talwar — Fri, 25 Aug 2017 10:00:10 GMT

May be these

=Count({<Incident = {"=CREATORGROUP = RESOLVEDGROUP"}>}Incident)

=Count({<Incident = {"=CREATORGROUP <> RESOLVEDGROUP"}>}Incident)

Re: Set analysis

0li5a3a — Fri, 25 Aug 2017 10:26:52 GMT

Hi Sunny,

Thank you for your answer but I need just a specific group like below

=Count({<Incident = {"=CREATORGROUP= {'Intern'}= RESOLVEDGROUP={'Intern'}"}>}Incident)

=Count({<Incident = {"=CREATORGROUP= {'Intern'}<> RESOLVEDGROUP={'Intern'}"}>}Incident)

But using nothing is displayed.

Regards,

Re: Set analysis

sunny_talwar — Fri, 25 Aug 2017 10:32:06 GMT

Can you show few rows of data.... I can make the first one work (equal), but not sure I understand they are not equal, but they both are Intern? What does that mean?

Re: Set analysis

Anonymous — Fri, 25 Aug 2017 10:42:58 GMT

perhaps:

=Count({<Incident = {"=CREATORGROUP= {'Intern'}, RESOLVEDGROUP-={'Intern'}"}>}Incident)

Re: Set analysis

0li5a3a — Fri, 25 Aug 2017 11:22:15 GMT

LOAD * INLINE [

Incident, CREATORGROUP, RESOLVEGROUP

1, Intern, Intern

2, Intern, Extern

3, Intern, Extern

4, Intern, Intern

5, Intern, Intern

6, Intern, Extern

7, Intern, Extern

8, Intern, Extern

9, Intern, Intern

10, Extern, Extern

];

This is my data and I need to count for ex : the total of incidents where the Creator is Intern and the 'Resolver' is 'Intern'. And the second request is to count all the tickets created by Intern and resolved by someone else.

Regards,

Re: Set analysis

0li5a3a — Fri, 25 Aug 2017 11:22:38 GMT

I tried but this doesn't works:(

Re: Set analysis

Anonymous — Fri, 25 Aug 2017 11:25:30 GMT

and that?:

=Count(

CREATORGROUP= {'Intern'}, RESOLVEDGROUP-={'Intern'}

Incident)

Re: Set analysis

tresB — Fri, 25 Aug 2017 11:32:47 GMT

R1: =Count({<CREATORGROUP={'Intern'}, RESOLVEGROUP={'Intern'}>}Incident)

R2: =Count({<CREATORGROUP={'Intern'}, RESOLVEGROUP-={'Intern'}>}Incident)

Re: Set analysis

0li5a3a — Fri, 25 Aug 2017 12:22:10 GMT

Thanks for you help