Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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)