Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

10 Replies
Highlighted
Partner
Partner

Re: Fetch tickets If its updated by particular Team ID

Hi

try this:

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

Highlighted
Contributor III
Contributor III

Re: Fetch tickets If its updated by particular Team ID

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
Highlighted
MVP
MVP

Re: Fetch tickets If its updated by particular Team ID

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;
Highlighted
Contributor III
Contributor III

Re: Fetch tickets If its updated by particular Team ID

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.

Highlighted
Contributor III
Contributor III

Re: Fetch tickets If its updated by particular Team ID

Can someone please help me urgently on the query.

Highlighted
MVP
MVP

Re: Fetch tickets If its updated by particular Team ID

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

Highlighted
Contributor III
Contributor III

Re: Fetch tickets If its updated by particular Team ID

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");
Highlighted
Specialist III
Specialist III

Re: Fetch tickets If its updated by particular Team ID

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;
Highlighted
Specialist III
Specialist III

Re: Fetch tickets If its updated by particular Team ID

Output.

commQV30.PNG