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

[shekhar_analyti]

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

[vinieme12]

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;

[shekhar_analyti]

can you please attach sample qvw .

[vinieme12 · Accepted solution]

attached!

[shekhar_analyti]

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 ?

[vinieme12]

try below

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

[vinieme12]

If your Original query is resolved please close the thread

Qlik Community Tip: Marking Replies as Correct or Helpful

[shekhar_analyti]

I see final resolution flag set to 0 for all records

[vinieme12]

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;