Display text data in Table Expression

harson — Sat, 16 Nov 2024 03:13:26 GMT

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

Re: Display text data in Table Expression

jaibau1993 — Fri, 21 Jun 2019 07:11:10 GMT

Hi!

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

Flag those agents that are CM or CP
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.

topic Display text data in Table Expression in QlikView

Display text data in Table Expression

Re: Display text data in Table Expression