Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ambers_sp
Contributor II
Contributor II

Count total Aggregation in Heatmap

Hi all,

I am wanting to display a heatmap with %. I'm doing the below but it is not working:

 

(count({<[Order_Complete]={'Y'}>}[Order_Hash]))/
//(count(total Order_Hash))

aggr( count(total [Order_Hash]), [YearWeek], [Weeks_Open_To_Closed] )

 

The heatmap has the X-axis as YearWeek and is the raised order date, Y-axis is the number of weeks it took an order to close. All I want to do is have a % of how many orders were closed in that YearWeek. If I select one particular Yearweek then the above code works, but want it to do it without selecting one week only.

Labels (4)
1 Solution

Accepted Solutions
Ambers_sp
Contributor II
Contributor II
Author

I managed to solve this in the end, allowed to show nulls in the dimension field of the heatmap and changed the code slightly too:

(Aggr(RangeSum(Above(Count({<[Order_Complete]={'Y'}>}Order_Hash), 0, RowNo())), YearWeek, (Weeks_Open_To_Closed, (NUMERIC, ASCENDING))))

/
count(total <YearWeek> Order_Hash)

View solution in original post

1 Reply
Ambers_sp
Contributor II
Contributor II
Author

I managed to solve this in the end, allowed to show nulls in the dimension field of the heatmap and changed the code slightly too:

(Aggr(RangeSum(Above(Count({<[Order_Complete]={'Y'}>}Order_Hash), 0, RowNo())), YearWeek, (Weeks_Open_To_Closed, (NUMERIC, ASCENDING))))

/
count(total <YearWeek> Order_Hash)