Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rathorep
Contributor III
Contributor III

Fetch tickets If its updated by particular Team ID

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

Labels (1)
10 Replies
fosuzuki
Partner - Specialist III
Partner - Specialist III

Hi

try this:

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

rathorep
Contributor III
Contributor III
Author

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.

TicketNumberTeamID
1904207713760
1904207712457
1904207713760
1904207712457
1904207713760
1904207712457
1904207712458
1904207713760
1903923813760
1903923812457
1903923813760
1903923812457
1903923812458
1903923813760
1903738513760
1903738512457
1903738512458
1903738513760
1644337412754
1644337412754
tresesco
MVP
MVP

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

Can someone please help me urgently on the query.

tresesco
MVP
MVP

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

rathorep
Contributor III
Contributor III
Author

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.

commQV30.PNG