topic Re: what should be load script to set a flag field "Instation" as 1 based on conditions below ? in QlikView

what should be load script to set a flag field "Instation" as 1 based on conditions below ?

shekhar_analyti — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: what should be load script to set a flag field "Instation" as 1 based on conditions below ?

vinieme12 — Wed, 23 Aug 2017 09:26:52 GMT

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;

Re: what should be load script to set a flag field "Instation" as 1 based on conditions below ?

shekhar_analyti — Wed, 23 Aug 2017 09:29:54 GMT

can you please attach sample qvw .

Re: what should be load script to set a flag field "Instation" as 1 based on conditions below ?

vinieme12 — Wed, 23 Aug 2017 09:31:27 GMT

attached!

Re: what should be load script to set a flag field "Instation" as 1 based on conditions below ?

shekhar_analyti — Wed, 23 Aug 2017 09:36:54 GMT

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 ?

Re: what should be load script to set a flag field "Instation" as 1 based on conditions below ?

vinieme12 — Wed, 23 Aug 2017 09:41:33 GMT

try below

=count( {<Ticket_ID = {="Count(Ticket_ID)>1"}>}Ticket_ID)

Re: what should be load script to set a flag field "Instation" as 1 based on conditions below ?

vinieme12 — Wed, 23 Aug 2017 09:42:14 GMT

If your Original query is resolved please close the thread

Qlik Community Tip: Marking Replies as Correct or Helpful

Re: what should be load script to set a flag field "Instation" as 1 based on conditions below ?

shekhar_analyti — Wed, 23 Aug 2017 10:35:31 GMT

I see final resolution flag set to 0 for all records

Re: what should be load script to set a flag field "Instation" as 1 based on conditions below ?

vinieme12 — Wed, 23 Aug 2017 10:37:35 GMT

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;