topic Re: Add a field based on another field in QlikView

Add a field based on another field

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I am trying to add a filed that has a number for 'TimeReported' on a service desk ticket number.

My table looks like this.

Service Desk Ticket	Time Reported
25222	.5
25222	4
29612	5

I want to add up Time Reported if the Service Desk Ticket number is the same, and only show one row instead of two separate rows.

Can I do this in the script or maybe an expression for the table?

any help is appreciated

Thank you,

Alam

Re: Add a field based on another field

consenit — Fri, 19 Dec 2014 15:52:48 GMT

Hi There.

You need a Straight Table with the Ticked Number as dimension and the SUM() of the time values as an expression.

Kind Regards,

Ernesto.

Re: Add a field based on another field

Anonymous — Fri, 19 Dec 2014 16:07:58 GMT

Hi Alam,

try below code in script:

Data:
LOAD [Service Desk Ticket],
Max([Time Reported]) AS [Time Reported]

FROM Table
GROUP BY [Service Desk Ticket];

Re: Add a field based on another field

kamal_sanguri — Fri, 19 Dec 2014 18:52:23 GMT

you don even need to change the script, use pivot table it will do it automatically for you.

kamal

Re: Add a field based on another field

kamal_sanguri — Fri, 19 Dec 2014 18:55:38 GMT

see this example..

Re: Add a field based on another field

its_anandrjs — Fri, 19 Dec 2014 19:07:23 GMT

Hi,

If you need all the rows sum up if there is single Service Desk Ticket then try this way

T1:
LOAD * Inline
[
Service Desk Ticket,    Time Reported
25222,    .5
25222,    4
29612,    5
];
NoConcatenate
LOAD [Service Desk Ticket],    sum([Time Reported]) as [Time Reported]
Resident T1 Group By [Service Desk Ticket];
DROP Table T1;

And in result you get the output as but question is what is the format of Time Reported here will it be minutes or what if values come in different format then you need to convert this field into minutes i guess.

Service Desk Ticket	Time Reported
25222	4.5
29612	5

Regards

Anand