Display text data in Table Expression

[harson]

Hello community,

Beginner on QlikView, I need help to create a table that I can't do,

I would like to have something like this (with Total) :

But in my table on QlikView, text data "CP" and "CM" are not displayed.

I put like Expression :

=if(jour = 11 and [temps prod]='CP','CP',
if(jour = 11 and [temps prod]='CM','CM',
Interval( sum(if(jour = 11, [temps prod])) ,'hh:mm:ss')
)
)

in attached my QVW file and below the txt data,

Thanks in advance for your help

DATA.txt :

Agent;agentid;Start;temps;

Agent1;1104;11/03/19 08:00;07:00:00
Agent2;1030;11/03/19 07:00;06:00:00
Agent3;1226;11/03/19 08:00;07:00:00
Agent4;1070;11/03/19 11:00;07:00:00
Agent5;1146;11/03/19 08:00;07:00:00
Agent6;1225;11/03/19 08:00;07:00:00
Agent7;1018;11/03/19 08:00;09:00:00
Agent8;1197;11/03/19 12:00;07:00:00
Agent9;1186;11/03/19 CP;CP
Agent10;1167;11/03/19 08:00;07:00:00
Agent11;1036;11/03/19 08:00;06:00:00
Agent12;1058;11/03/19 08:00;07:00:00
Agent13;1037;11/03/19 CM;CM
Agent14;1103;11/03/19 08:00;06:00:00
Agent15;1122;11/03/19 08:00;05:00:00

Agent1;1104;12/03/19 11:00;07:00:00
Agent2;1030;12/03/19 08:00;07:00:00
Agent3;1226;12/03/19 08:00;07:00:00
Agent4;1070;12/03/19 08:00;07:00:00
Agent5;1146;12/03/19 08:00;07:00:00
Agent6;1225;12/03/19 08:00;07:00:00
Agent7;1018;12/03/19 08:00;09:00:00
Agent8;1197;12/03/19 08:00;07:00:00
Agent9;1186;12/03/19 CM;CM
Agent10;1167;12/03/19 12:00;07:00:00
Agent11;1036;12/03/19 08:00;06:00:00
Agent12;1058;12/03/19 07:00;07:00:00
Agent13;1037;12/03/19 CP;CP
Agent14;1103;12/03/19 08:00;06:00:00
Agent15;1122;12/03/19 08:00;05:00:00

[jaibau1993 · Accepted solution]

Hi!

I think you should think carefully what you are trying to achieve.

1. Flag those agents that are CM or CP 
2. Use set analysis instead of Ifs

Please, see the attached file. I use your sample data to flag the agents (script side) and I could build up the following table:

Regards,

Jaime.