Fetch tickets If its updated by particular Team ID

[rathorep]

Hello,

I need help to filter on records-

My Data set contains-> Tickets resolved by multiple teams, But I need to get tickets only if its updated by my Team includes TeamID(13760,12457,12458) .

I need all the entries of ticket i.e. how many times updates perform on ticket but only if atleast once its updated by any of these TeamID(13760,12457,12458).

I have 2 columns:Just sharing Dummy Data:

TicketNumber, Field modified by TeamID

21                                      21435

31                                      12454

32                                      13760

41                                       12458

[fosuzuki]

Hi

try this:

count({<TeamID={13760,12457,12458}>} TicketNumber)

[rathorep]

Hello Thanks for the reply, but iam trying to do it in where clause in load editor where i have to restrict the data , this expression is showing invalid. Please find sample data: In the below data i have multiple records for same ticket but i need to have only tickets where its modified by atleast this team id- 12457 like for example last record is not modified by Teamid-12457 so i want to exclude that from load editor.

TicketNumber	TeamID
19042077	13760
19042077	12457
19042077	13760
19042077	12457
19042077	13760
19042077	12457
19042077	12458
19042077	13760
19039238	13760
19039238	12457
19039238	13760
19039238	12457
19039238	12458
19039238	13760
19037385	13760
19037385	12457
19037385	12458
19037385	13760
16443374	12754
16443374	12754

[tresesco]

Try like this:

temp:
LOAD 
	TicketNumber as TicketNumberMaster  
FROM
[https://community.qlik.com/t5/Qlik-Sense-App-Development/Fetch-tickets-If-its-updated-by-particular-Team-ID/td-p/1723210]
(html, utf8, UserAgent is 'Mozilla/5.0', embedded labels, table is @1)
where Match(TeamID,12457);  //YOU CAN ADD MORE TeamIDs here

Final:
Load
	*
FROM
[https://community.qlik.com/t5/Qlik-Sense-App-Development/Fetch-tickets-If-its-updated-by-particular-Team-ID/td-p/1723210]
(html, utf8, UserAgent is 'Mozilla/5.0', embedded labels, table is @1)
where Exists(TicketNumberMaster, TicketNumber);

Drop table temp;

[rathorep]

Hello,

I have the following expression:

History:
LOAD
"TicketNumber",
"Field 2",
"Field 3",
"Field 4",
"Field 5",
"Field 6",
"Field 7",
"Field 8",
Match("TeamID",13760) as "TeamID"


FROM [lib://CORPORATE /History.qvd]
(qvd)
where ( ([Field 2]='Status' and [Field 3]='Closed') or [Field 5]='Assignee Group')
and Exists("TicketNumber", 13760);

This is not giving correct result.

[rathorep]

Can someone please help me urgently on the query.

[tresesco]

Try exactly the way I showed above and then let know - if that doesn't work.

[rathorep]

For the line-

where Exists(TicketNumberMaster, TicketNumber);

Do you want me to hard code ticket number as this is not working and throwing error-

The following error occurred:

Unexpected token: 'TicketNumberMaster', expected one of: 'txt', 'Table', 'tab', 'biff', 'dif', 'fix', 'html'.

Expression i am using is - 

temp:
Winap:
LOAD
"Ticket Number" as TicketNumberMaster,
"Field 1",
"Field 2
"Field 3
"Field 4
"Field 5


FROM [lib://CORP.qvd]
(qvd)
where Match([Field Modified Group ID],12457);
Final:
Load
*
FROM
[lib://CORP.qvd]
where Exists(TicketNumberMaster, "Ticket Number");

[Saravanan_Desingh]

One solution is.

NoExclude:
Mapping
LOAD *, 'Y' INLINE [
    NoExclude
    12457
    12764
];

tab1:
LOAD *, ApplyMap('NoExclude',TeamID,Null()) As Flag INLINE [
    TicketNumber, TeamID
    19042077, 13760
    19042077, 12457
    19042077, 13760
    19042077, 12457
    19042077, 13760
    19042077, 12457
    19042077, 12458
    19042077, 13760
    19039238, 13760
    19039238, 12457
    19039238, 13760
    19039238, 12457
    19039238, 12458
    19039238, 13760
    19037385, 13760
    19037385, 12457
    19037385, 12458
    19037385, 13760
    16443374, 12754
    16443374, 12754
    16443375, 12754
    16443375, 12764        
];

Left Join(tab1)
LOAD TicketNumber, if(Concat(DISTINCT Flag)='Y','N','Y') As Exclude_Flag
Resident tab1
Group By TicketNumber;

Drop Field Flag;

[Saravanan_Desingh]

Output.