Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
0li5a3a
Creator III
Creator III

Set analysis

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,

C

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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

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

Capture.PNG

View solution in original post

9 Replies
sunny_talwar

May be these

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

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

0li5a3a
Creator III
Creator III
Author

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,

C

sunny_talwar

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?

Anonymous
Not applicable

perhaps:

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

0li5a3a
Creator III
Creator III
Author

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,

C

0li5a3a
Creator III
Creator III
Author

I tried but this doesn't works:(

Anonymous
Not applicable

and that?:

=Count(

{<

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

>}

Incident)

tresesco
MVP
MVP

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

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

Capture.PNG

0li5a3a
Creator III
Creator III
Author

Thanks for you help