Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Block chart fractile upper/lower limit exceeding memory

I have values like

  

CountryValue
0.17
DNK3.53
ITA1.16
DEU0.73
MEX0.73
JPN_ROW0.54
SWE0.52
NLD0.48
FRA0.39
KOR_ROW0.33
KOR0.29
JPN0.28
FIN0.25
AUS0.24
MYS0.22
SGP0.20
GBR0.20
CAN0.20

Using the colormix wizard with Sum(TotalConvValue), default normalised upper and lower limits produces a very uniform color block chart  except for 1 patch since the DNK value skews the whole table.

If I set the upper and lower limits manually with Fractile(Aggr(Sum(TotalConvValue),Feeder),0.9), Fractile(Aggr(Sum(TotalConvValue),Feeder),0.1), the chart throws an allocated memory exceeded error.

How do I overcome this for a nicely distinguished heat map on the block chart?

0 Replies