topic Re: Fetch tickets If its updated by particular Team ID in App Development

Fetch tickets If its updated by particular Team ID

rathorep — Sat, 16 Nov 2024 18:25:43 GMT

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

Re: Fetch tickets If its updated by particular Team ID

fosuzuki — Mon, 29 Jun 2020 19:16:19 GMT

try this:

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

Re: Fetch tickets If its updated by particular Team ID

rathorep — Tue, 30 Jun 2020 05:03:59 GMT

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

Re: Fetch tickets If its updated by particular Team ID

tresB — Tue, 30 Jun 2020 05:20:41 GMT

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;

Re: Fetch tickets If its updated by particular Team ID

rathorep — Tue, 30 Jun 2020 06:54:40 GMT

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.

Re: Fetch tickets If its updated by particular Team ID

rathorep — Fri, 03 Jul 2020 06:04:57 GMT

Can someone please help me urgently on the query.

Re: Fetch tickets If its updated by particular Team ID

tresB — Fri, 03 Jul 2020 06:13:39 GMT

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

Re: Fetch tickets If its updated by particular Team ID

rathorep — Mon, 06 Jul 2020 12:37:03 GMT

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");

Re: Fetch tickets If its updated by particular Team ID

Saravanan_Desingh — Tue, 07 Jul 2020 03:06:20 GMT

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;

Re: Fetch tickets If its updated by particular Team ID

Saravanan_Desingh — Tue, 07 Jul 2020 03:06:54 GMT

Output.

Re: Fetch tickets If its updated by particular Team ID

rathorep — Thu, 09 Jul 2020 09:56:22 GMT

Hello,

In the output you have provided, all the line entries of 19042077 are not coming.