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

[SGV]

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.

[Oleg_Troyansky]

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. 

[rwunderlich · Accepted solution]

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

[SGV]

@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

[Oleg_Troyansky]

@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 

[SGV]

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