topic Re: How do I sum this condition? in QlikView

How do I sum this condition?

Paknanarn23 — Mon, 26 Jan 2026 18:19:17 GMT

I want to sum AmpH from Date Out starting at 05:00:00 AM of the first day to 05:00:00 AM of the next day.

Re: How do I sum this condition?

tresB — Fri, 03 Feb 2023 04:38:19 GMT

Can you explain how you are getting these numbers and how do you want to sum them?

Re: How do I sum this condition?

Paknanarn23 — Fri, 03 Feb 2023 04:43:27 GMT

Hi Tresesco,

I got this sum from Database, it's a value fetched from Database at all.

where I want to sum the Amph values from Date Out 5:00 AM of the first selected date to 5:00 AM of the last selected date.

Re: How do I sum this condition?

tresB — Fri, 03 Feb 2023 04:48:28 GMT

I am still not clear about your 5 a.m. part. Could you explain with a selection case?

Re: How do I sum this condition?

Paknanarn23 — Fri, 03 Feb 2023 04:56:04 GMT

It's not a choice. But it is a condition for sum(AmpH) that if the time is 5am, sum(ampH) will come out in each Cu Tank

For example, if CU TANK = 26, you will get this value.

The time will start from 6am on January 30, 2023 until 4am on January 31, 2023

Re: How do I sum this condition?

avkeep01 — Fri, 03 Feb 2023 09:06:18 GMT

Hi @Paknanarn23 ,

You could use this to get 1 date for all values between 05:00:00 this day and 05:00:00 the next day. If the date is later then 12:00:00 PM then it will substract 1 day for the timestamps before 05:00:00.

TIMESTAMP(DATE(IF(TIME(DATE_OUT-DAYSTART(DATE_OUT))>=TIME('05:00:00') ,DAYSTART(DATE_OUT),DAYSTART(DATE_OUT)-1),'DD-MM-YYYY')+TIME('05:00:00'),'M/DD/YYYY h:mm:ss TT') AS GroupByDate

This is the result: