Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Or condition in set analysis

Hi,

i am facing an issue, i heave date pickers and two list boxes like as below.

Originate team
ABC india
ABC singapore
cs india
xyz
Assigned team
ABC india
MNO corp
xyz ltd
abc singapore
KLM Prod

Issue: usually tickets are assigned to aaigned team and orinating by orginating team most of the tickets are handled by originating team.

but few tickets are handled by assigned team.

EXAMPLE: if i have 100 tickets assignd to ABC india and in that 90 tickets are handled by ABC india in originating team. remaining 10 tickets are handled by abc singapore.

Problem:  i have given date range and when i select ABC india(Originating team) it is giving 90 tickets. but actual tickets are 100.

when i select ABC india i need count 100 how can i get please help me.

Thanks.

1 Reply
sunny_talwar

May be this:

Count({$+<[Assigned team] = p([Orginiate team])>}Tickets)