topic Re: Find Max of a time in App Development

Find Max of a time

hugomeuris — Fri, 02 Feb 2018 14:59:32 GMT

Hello every one,

I'm facing a problem with Qlik Sence I couldn't manage to fix for now, so I thought I should ask the community for some help 😃

What I'm looking for is following :

Everyday (column 2) I get a working time (column 4) for each line of production (column 3)

I would like to add a column thank to set analysis, which would give me the maximum of working time between the 2 lines of production.

(like shown on the picture)

I tried to use the Max() function but I can't use it on the operator SUM => Max(Sum(TPSPASSE)) doesn't worked.

By looking through some docs and posts I got that I had to use Aggr(), but all I tried doesn't work...

Has please someone an idea what I should write in set analysis to get the wanted column ?

Thank for your time and consideration

Re: Find Max of a time

sunny_talwar — Fri, 02 Feb 2018 16:58:21 GMT

Try this

Max(TOTAL <PFC_Jour, JOUR_PRODUCTION> Sum(TPSPASSE), PFC_Jour, JOUR_PRODUCTION, Ligne))

Re: Find Max of a time

hugomeuris — Mon, 05 Feb 2018 08:11:50 GMT

Thank you Sunny for your answer but,

it Gaves me : "Error in expression : Nested aggregation not allowed"

I think it's because there is a sum in the function max : Max(Sum()) is impossible.

Re: Find Max of a time

sunny_talwar — Mon, 05 Feb 2018 16:53:08 GMT

Forgot to add Aggr()

Max(TOTAL <PFC_Jour, JOUR_PRODUCTION> Aggr(Sum(TPSPASSE), PFC_Jour, JOUR_PRODUCTION, Ligne))

Re: Find Max of a time

hugomeuris — Tue, 06 Feb 2018 08:27:45 GMT

It gives me '-' also NULL values.

And this time I have no clue why 😕 ...

Re: Find Max of a time

sunny_talwar — Tue, 06 Feb 2018 16:12:36 GMT

Would you be able to share a sample to check this out?

Re: Find Max of a time

hugomeuris — Tue, 06 Feb 2018 16:20:42 GMT

I would like to but I'm affraid I don't have the access and the possibility to do that 😕 ...

Re: Find Max of a time

sunny_talwar — Tue, 06 Feb 2018 16:21:33 GMT

Few rows of raw dummy data with the expected output?

Re: Find Max of a time

hugomeuris — Tue, 06 Feb 2018 16:28:56 GMT

oh ... It's what I sent at my first post with a pic ?

I don't know how to share it with an other way, maybe with an excel file ?

Re: Find Max of a time

sunny_talwar — Tue, 06 Feb 2018 16:30:27 GMT

Yes, in an Excel file would be great

Uploading a Sample

Re: Find Max of a time

hugomeuris — Tue, 06 Feb 2018 16:44:47 GMT

Didn't know I could attach files like that

Hope it'll help to see better what I try to obtain ...

Re: Find Max of a time

sunny_talwar — Tue, 06 Feb 2018 16:51:48 GMT

Is your field name called Ligne or PFC_Ligne de conditionnement??

You just need to use the exact field names to get it to work

Max(TOTAL <PFC_Jour, JOUR_PRODUCTION> Aggr(Sum(TPSPASSE), PFC_Jour, JOUR_PRODUCTION, [PFC_Ligne de conditionnement]))

Similarly, use the right field names for PFC_Jour and JOUR_PRODUCTION

Re: Find Max of a time

hugomeuris — Mon, 12 Feb 2018 15:23:37 GMT

Thanks a lot Sunny , it's working 😃

Re: Find Max of a time

sunny_talwar — Mon, 12 Feb 2018 16:29:04 GMT

Awesome, please close the thread by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny