topic Re: To Calculate maximum value from 5 different field related to some customer id. in QlikView

To Calculate maximum value from 5 different field related to some customer id.

Thu, 19 Dec 2013 12:00:08 GMT

Hello everyone,

I want to pick the maximum values among different fields related to customer Id

My Table is in the form of:

CaseId OpenToAssignTime AssignToDevelopment DevelopmentToTest TestToResolve

1 2 3 1.5 1

2 2.5 3.5 2 2.5

3 1.2 1.6 1.7 3

so for each caseId i need to calculate the maximum value with field name associated among above time fields.

thanks and Regards.

Thu, 19 Dec 2013 12:27:45 GMT

Hi Nupur

here is an exemple

best regards

Chris

Anonymous — Thu, 19 Dec 2013 12:44:33 GMT

LOAD * inline

[

CaseId , OpenToAssignTime , AssignToDevelopment , DevelopmentToTest , TestToResolve

1 , 2 , 3 , 1.5 , 1

2 , 2.5 , 3.5 , 2 , 2.5

3 , 1.2 , 1.6 , 1.7 , 3

];

CrossTable(task,value)

load

resident abc;

drop table abc;

then craete a straight table add CaseId as dimension.

then use expression =Aggr(max(value),CaseId)