Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
what should be load script to set a flag field "Instation" as 1 based on conditions below ?
I want to create two flags with value as 1
1) Instation Flag - If a ticket Id is resolved by single assigned team and its Resolved Field is not equal to N
2) Final Resolution flag - it should be 1 for all Ticket id whose Resolved field is not equal to N
Thanks & Regards
Shekar
attached!
Try below
fact:
LOAD Request_Type,
Ticket_ID,
Assigned_To,
Assigned_Dt,
Resolved_Dt,
Resolved
FROM
[xxxxxxxxxxxxxxxxxx]
(ooxml, embedded labels, table is data);
TicketFlag:
LOAD
Ticket_ID,TeamCount,ResolvedFlag,
if(TeamCount=1,1,0) as Instation_flag,
if(Match(ResolvedFlag,'N')=0,1,0) as Final_Resolution_flag;
LOAD Ticket_ID,Count(DISTINCT Assigned_To) as TeamCount,MaxString(Resolved) as ResolvedFlag
Resident fact
Group by Ticket_ID;
can you please attach sample qvw .
attached!
Thank you vineeth .
In case of simple load
fact:
LOAD Request_Type,
Ticket_ID,
Assigned_To,
Assigned_Dt,
Resolved_Dt,
Resolved
FROM
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
In textbox i want to show the count of all those ticket id which have multiple instances
i tried below expression , but did not work
=if(aggr(Count(Ticket_ID),Ticket_ID)>1,Count({1}Ticket_ID))
Can you please help with expression ?
try below
=count( {<Ticket_ID = {="Count(Ticket_ID)>1"}>}Ticket_ID)
If your Original query is resolved please close the thread
Qlik Community Tip: Marking Replies as Correct or Helpful
I see final resolution flag set to 0 for all records
Change this part
TicketFlag:
LOAD
Ticket_ID,TeamCount,ResolvedFlag,
if(TeamCount=1,1,0) as Instation_flag,
if(Match(ResolvedFlag,'N'),0,1) as Final_Resolution_flag;
LOAD Ticket_ID,Count(DISTINCT Assigned_To) as TeamCount,MaxString(Resolved) as ResolvedFlag
Resident fact
Group by Ticket_ID;