topic Re: Find out which Day (Sun, Mon, Tue) etc. has the highest value occurred (aggregated at a weekly level) in App Development

Find out which Day (Sun, Mon, Tue) etc. has the highest value occurred (aggregated at a weekly level)

SGV — Thu, 24 Jul 2025 18:01:08 GMT

Hello,

I want to create a bar chart like below.

Background Logic:

Sample data of temperatures has been attached below.

requirement:

For each date, there is a highest and a lowest value. I want to calculate on which days the highest and lowest values occurs , aggregated at a weekly level. Please see attached 1st pic.

This will allow me to understand, on average, on what days I need to turn on the cooling systems.

Re: Find out which Day (Sun, Mon, Tue) etc. has the highest value occurred (aggregated at a weekly level)

Oleg_Troyansky — Thu, 24 Jul 2025 19:09:08 GMT

Hi there,

This is a tricky problem that can be solved with the function FirstSortedValue(), in combination with the advanced aggregation function AGGR().

Allow me to invite you to my Qlik Expert Class that will take place in Vienna, Austria on March 22nd, where I will be teaching advanced development techniques. This problem is just one of many hands-on exercises in my Set Analysis and AGGR() session.

Re: Find out which Day (Sun, Mon, Tue) etc. has the highest value occurred (aggregated at a weekly level)

rwunderlich — Thu, 24 Jul 2025 19:04:59 GMT

In script it can be solved like:

Daily:

LOAD

Date("Date") as Date,

WeekName("Date") as Week,

WeekDay("Date") as WeekDay,

high,

low

FROM [lib://downloads (azuread_robwunderlich)/Qlik Sense - Untitled - Table - July 24, 2025 (1).xlsx]

(ooxml, embedded labels, table is Sheet1);

Left Join (Daily)

LOAD

Week,

Max(high) as high,

1 as IsHigh

Resident Daily

Group by Week;

Left Join (Daily)

LOAD

Week,

Min(low) as low,

1 as IsLow

Resident Daily

Group by Week;

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

Re: Find out which Day (Sun, Mon, Tue) etc. has the highest value occurred (aggregated at a weekly level)

SGV — Thu, 24 Jul 2025 19:27:10 GMT

@rwunderlich I tried like below as I can only implement a Front End solution:

Measure (Y axis in bar chart)

Dimension (X-axis in bar chart) - (WeekDay = Sun, Sat etc. )

However I am not getting the correct answers

Re: Find out which Day (Sun, Mon, Tue) etc. has the highest value occurred (aggregated at a weekly level)

Oleg_Troyansky — Thu, 24 Jul 2025 19:30:14 GMT

@SGV try this:

Dimension: WeekName

Measures:

High:

FirstSortedValue( WeekDay,

- AGGR(max(High), WeekName, WeekDay)

)

Low:

FirstSortedValue( WeekDay,

AGGR(min(Low), WeekName, WeekDay)

)

Cheers,

Oleg Troyansky

Re: Find out which Day (Sun, Mon, Tue) etc. has the highest value occurred (aggregated at a weekly level)

SGV — Fri, 25 Jul 2025 01:25:03 GMT

I don't think this solution is working as I need to use Dayname (Sat, Sun, Tue) etc. in the X axis (as a Dimension). Rob's solution works but I can only do this in the front end